2024年1月19日发(作者：)

SELECT pg_e AS "函数名称", pg_e AS "返回值数据类型", pg_gs AS "参数个数"FROM pg_procJOIN pg_type ON (pg_type = pg_)WHERE pg_e != 'void' AND pronamespace = (SELECT pg_ FROM pg_namespace WHERE nspname = 'public'); 当然也可以只查询函数名：select

pg_e

from

pg_proc

join pg_type

on (pg_type = pg_)

where

pg_e != 'void'

and pronamespace = (select pg_

from pg_namespace

where nspname = 'public')10. 查询某个表的主外键约束的所有信息：SELECT * FROM

information__constraints AS tc

JOIN information__column_usage AS kcu ON aint_name = aint_name JOIN information_aint_column_usage AS ccu ON aint_name = aint_name WHERE _name like '表名';11. 查询某个表的主键约束/外键约束：SELECT * FROM

information__constraints AS tc

JOIN information__column_usage AS kcu ON aint_name = aint_name JOIN information_aint_column_usage AS ccu ON aint_name = aint_name WHERE constraint_type = 'FOREIGN KEY/PRIMARY KEY' AND _name like '表名';