PostgreSQL数据表的备份和恢复

备份数据

copy arc_rolemc(id,mcid,roleid,type) to '/tmp/arc_rolemc.csv' with csv; 

拷贝文件

scp arc_rolemc.csv 172.16.1.101:/tmp/

恢复数据

copy arc_rolemc(id,mcid,roleid,type) from '/tmp/arc_rolemc.csv' with csv;
\d+ arc_rolemc
select max(id) from arc_rolemc;
alter sequence arc_rolemc_id_seq restart 1110;