随笔分类 -  gp.字典表

摘要：【sql】 select a.tablename as tname b.remark as remark from ( select table_name tablename from information_schem.tables where upper(table_schema)=upper( 阅读全文

摘要：【SQL】 select attname as name, attnum as orderNum, col_description(attrelid,attnum) as remark from pg_attribute where attrelid='your table'::regclass a 阅读全文

摘要：【SQL】 一行流方式： select count(*) from information_schema.table where table_schema='your schema' and table_type='BASE TABLE' and upper(table_name)=upper('y 阅读全文