得到所有表的信息:
select * from information_schema.columns
where table_schema='public' and table_name<>'pg_stat_statements';
得到所有表的列名:
select column_name from information_schema.columns
where table_schema='public' and table_name<>'pg_stat_statements';
得到表"table"的列名
select column_name from information_schema.columns
where table_schema='public' and table_name='table';
-----------eg:
select column_name||',' from information_schema.columns
where table_schema='public' and table_name<>'pg_stat_statements' and table_name='jjdb';