查看pg数据库的表名字段详细描述信息语句
select t1.schemaname,t1.tablename,t1.tableowner,t3.attname,t3.attnum,format_type(t3.atttypid,t3.atttypmod),t5.description
from pg_tables t1
left join pg_namespace t4
on t1.schemaname=t4.nspname
left join PG_class t2
on t1.tablename=t2.relname
and t4.oid=t2
原创
2020-10-23 20:51:09 ·
2606 阅读 ·
0 评论