查看pg数据库的表名字段详细描述信息语句
select t1.schemaname,t1.tablename,t1.tableowner,t3.attname,t3.attnum,format_type(t3.atttypid,t3.atttypmod),t5.descriptionfrom pg_tables t1left join pg_namespace t4on t1.schemaname=t4.nspnameleft join PG_class t2on t1.tablename=t2.relnameand t4.oid=t2
原创
2020-10-23 20:51:09 ·
2655 阅读 ·
0 评论