PostgreSQL擷取table名，欄位名

標籤：get   ase   mysql   name   blog   nbsp   資料   net   class   

PostgreSQL擷取資料庫中所有table名：

SELECT tablenameFROM pg_tablesWHERE tablename NOT LIKE ‘pg%‘      AND tablename NOT LIKE ‘sql_%‘ORDER BY  tablename;

 

PostgreSQL擷取資料庫中所有table名及table的註解資訊：

SELECT tablename,        obj_description(relfilenode,        ‘pg_class‘)FROM pg_tables a, pg_class bWHERE a.tablename = b.relname        AND a.tablename NOT LIKE ‘pg%‘        AND a.tablename NOT LIKE ‘sql_%‘ORDER BY  a.tablename;

PostgreSQL擷取指定table的所有欄位資訊：

SELECT col_description(a.attrelid,        a.attnum) AS comment,        format_type(a.atttypid,        a.atttypmod) AS type,        a.attname AS name,         a.attnotnull AS notnullFROM pg_class AS c,pg_attribute AS aWHERE c.relname = ‘tablename‘        AND a.attrelid = c.oid        AND a.attnum>0

 

PostgreSQL擷取table名，欄位名