Mega Code Archive

 

Categories / PostgreSQL / Postgre SQL

 

Querying a system table

postgres=# -- Querying a system table: pg_language postgres=# postgres=# SELECT * FROM pg_language;  lanname  | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl ----------+---------+--------------+---------------+--------------+--------  internal | f       | f            |             0 |         2246 |  c        | f       | f            |             0 |         2247 |  sql      | f       | t            |             0 |         2248 | (3 rows) postgres=#