PostgreSQL 查找当前数据库的所有表、字段
查看当前所有表SELECTtablenameFROMpg_tablesWHEREtablename NOT LIKE'pg%'AND tablename NOT LIKE'sql_%'ORDER BYtablename;查看当前表的所有字段SELECTC.relname,A.attname AS NAME,A.attnotnull AS NOTNULL,format_type ( A.atttyp
·
查看当前所有表
SELECT
tablename
FROM
pg_tables
WHERE
tablename NOT LIKE'pg%'
AND tablename NOT LIKE'sql_%'
ORDER BY
tablename;
查看当前表的所有字段
SELECT
C.relname,
A.attname AS NAME,
A.attnotnull AS NOTNULL,
format_type ( A.atttypid, A.atttypmod ) AS TYPE,
col_description ( A.attrelid, A.attnum ) AS COMMENT
FROM
pg_class AS C,
pg_attribute AS A
WHERE
C.relname = '表名'
AND A.attrelid = C.oid
AND A.attnum > 0
查看当前所有表的所有字段
SELECT C
.relname,
A.attname AS NAME,
A.attnotnull AS NOTNULL,
format_type ( A.atttypid, A.atttypmod ) AS TYPE,
col_description ( A.attrelid, A.attnum ) AS COMMENT
FROM
pg_class AS C,
pg_attribute AS A
WHERE
C.relname IN ( SELECT tablename FROM pg_tables WHERE tablename NOT LIKE'pg%' AND tablename NOT LIKE'sql_%' ORDER BY tablename )
AND A.attrelid = C.oid
AND A.attnum > 0
更多推荐
所有评论(0)