1、查询所有表名字,默认schema名字是public
SELECT
tablename
FROM
pg_tables
WHERE
schemaname = 'public'
2、查询已知表名tableName的所有字段的字段名、类型、是否为空、注释
SELECT
A.attname AS NAME,
format_type(A.atttypid, A.atttypmod) AS TYPE,
A
1、查询所有表名字,默认schema名字是public
SELECT
tablename
FROM
pg_tables
WHERE
schemaname = 'public'
2、查询已知表名tableName的所有字段的字段名、类型、是否为空、注释
SELECT
A.attname AS NAME,
format_type(A.atttypid, A.atttypmod) AS TYPE,
A