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;
页:
[1]