SELECT
A.attnum,
( SELECT description FROM pg_catalog.pg_description WHERE objoid = A.attrelid AND objsubid = A.attnum ) AS descript,
A.attname,
( select typname from pg_type where oid = A.atttypid) AS type,
A.atttypmod AS data_type
FROM
pg_catalog.pg_attribute A
WHERE
1 = 1
AND A.attrelid = ( SELECT oid FROM pg_class WHERE relname = '表名' )
AND A.attnum > 0
AND NOT A.attisdropped
ORDER BY
A.attnum;
postgresql 查询表结构
免责声明:文章转载自《postgresql 查询表结构》仅用于学习参考。如对内容有疑问,请及时联系本站处理。
上篇服务器IP地址后修改SQL Server配置【HTML5版】导出Table数据并保存为Excel下篇
宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=