1.查询postgre的表所有字段列

select table_name, column_name from information_schema.columns
where table_schema='public' and table_name='t_user';

2.将上面的列，group_concat拼接

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。 
select string_agg(column_name,',') 
from information_schema.columns
where table_schema='public' and table_name='t_user';

 拼表的自字段查询

select 'select '
||(
select string_agg(column_name,',') from information_schema.columns
where table_schema='public' and table_name='t_user'
)
||' from t_user';

----------------
select id,name,cnname,password from t_user

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄