pgsql查表结构和函数内容

方式一：

SELECT a.attnum,
       a.attname AS field,
       t.typname AS type,
       a.attlen AS length,
       a.atttypmod AS lengthvar,
       a.attnotnull AS notnull,
       b.description AS comment
  FROM pg_class c,
       pg_attribute a
  LEFT OUTER JOIN pg_description b 
    ON a.attrelid=b.objoid 
   AND a.attnum = b.objsubid,
       pg_type t
 WHERE c.relname = 'tablename'
   and a.attnum > 0
   and a.attrelid = c.oid
   and a.atttypid = t.oid
 ORDER BY a.attnum;

--查询prosrc显示空白，因为第一行记录默认是\t，复制出来，既可以看到函数内容
 select prosrc from pg_proc where proname='function_name'

方式二：

 --使用psql进入命令窗口
 
 psql -d dw
 
 --查看表结构
 [dw] \d tablename
 
  --查看表结构
 [dw] \df+ function_namename