复制表
//带表结构与数据
CREATE TABLE table_name_bak AS(SELECT * FROM table_name);
如果只复制表结构,在select语句中limit 0即可。
//只复制数据
INSERT INTO table_name_bak SELECT * FROM table_name;
清空表
TRUNCATE table_name;
//真空表
VACUUM zwfw_hy_query_file
查询表
//查询表数据量
select relname as TABLE_NAME, reltuples as rowCounts from pg_class where relkind = ‘r’ order by rowCounts desc