PostgreSQL 常用SQL（持续更新...）

select
  relname as tabname,
  obj_description(c.oid)
from
  pg_class c
where
  obj_description(c.oid) is not null ;

SELECT * FROM pg_views;
desc v_object_mfr_where_used
select
  a.attnum as "序号",
  c.relname as "表名",
  cast(obj_description(c.oid) as varchar) as "表名描述",
  a.attname as "列名",
  concat_ws('', t.typname, SUBSTRING(format_type(a.atttypid, a.atttypmod) from '\(.*\)')) as "字段类型",
  d.description as "备注"
from
  pg_attribute a
left join pg_description d on
  d.objoid = a.attrelid
  and d.objsubid = a.attnum
left join pg_class c on
  a.attrelid = c.oid
left join pg_type t on
  a.atttypid = t.oid
where
  a.attnum >= 0
  and c.relname like '表名'
order by
  c.relname desc,
  a.attnum asc

SELECT column_default AS default_value FROM information_schema.columns WHERE  table_name='表名' AND column_name='字段名' LIMIT 1;