Shulou(Shulou.com)06/01 Report--

Postgresql view table structure and field comments

1: view table structure (field) information:

Select table_name,column_name,data_type,character_maximum_length from information.columns where table_schema='dd' and table_name='department'

Second: view the field comment information:

Select a.attnum, (select description from pg_catalog.pg_description where objoid=a.attrelid and objsubid=a.attnum) as descript, a.attname.formatting and not a.attisdropped order by a.attnum type (a.atttypidmena.atttypmod) as data_type from pg_catalog.pg_attribute a where 1century 1 and a.attrelid = (select oid from pg_class where relname='department') and a.attnum > 0 and not a.attisdropped order by a.attnum

Note: where dd is the schema name and department is the table name *

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.