在postgresql 裏如何撈取資料表欄位?

#在postgresql 裏如何撈取資料表欄位

#範例撈取pg_tables的欄位屬性

SELECT a.attname,b.relname,a.attnum

FROM PG_ATTRIBUTE a, PG_CLASS b

WHERE b.oid = a.attrelid

AND b.relname = 'pg_tables'

AND a.attname NOT IN ('tableoid', 'cmax', 'xmax', 'cmin','xmin', 'ctid')

order by attnum;