如何找到加载到EnterpriseDB中的语言？

How can I find what languages have been loaded into EnterpriseDB(PL/pgsql, SPL, Java)? EnterpriseDB is built on top of PostgreSQL if anyone knows of a way to find the loaded languages on PostgreSQL. It should work the same.

如何找到已加载到EnterpriseDB中的语言(PL / pgsql,SPL,Java)?如果有人知道在PostgreSQL上找到加载语言的方法,那么EnterpriseDB是建立在PostgreSQL之上的。它应该工作相同。

2 个解决方案

#1

The installed languages are registered in pl_language, e.g.:

已安装的语言在pl_language中注册,例如:

steve@steve@[local] =# select * from pg_language;
 lanname  | lanowner | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
----------+----------+---------+--------------+---------------+--------------+--------
 internal |       10 | f       | f            |             0 |         2246 |
 c        |       10 | f       | f            |             0 |         2247 |
 sql      |       10 | f       | t            |             0 |         2248 |
 plpgsql  |       10 | t       | t            |         73259 |        73260 |
(4 rows)

#2

Check the "pg_language" system catalogue (hopefully EDB is not that different from Postgres).

检查“pg_language”系统目录(希望EDB与Postgres没有什么不同)。

#1