GaussDB 常用语句

-- 查询表数据信息(推荐)
select owner,schema,table name,comments,concat('select * from ',schema,'.',table_name,' limit 100;')
from pg_catalog.db_tab_comments where owner = 'bos3dk'
and schema ='tradingdb'
and table name like '%order%'
and comments like'%委托%';

-- 查询表字段数据信息(推荐)
select owner,schema,table_name,column_name,data_type,data length,`collation`,comments
from pg_catalog.db tab_columns where owner = 'bos3dk' 
and schema ='tradingdb'
and table_name like '%t_order%' 
and column name like'%agw%' 
and comments like'%流水%';

-- 复制结构和数据(Ps:主键不会复制)
select *into pubdb.t_return_code_bak from pubdb.t_return_code

--从一个表复制数据保存到另一个表中
insert into pubdb.t_return_code_bak select * from pubdb.t_return_code;