1 登录数据库
psql -U 用户名 -d 数据库
psql -U yuhui -d yanglao
2 复制表
insert into yanglaojigou_20240415
(key, province, city, district, name, address, price_low, price_high, beds, property, type, created_time)
select
key, province, city, district, name, address, price_low, price_high, beds, property, type, created_time
from yanglaojigou
where
is_done=true and address!='地址:' and property!='' and (price_low!=0 or price_high!=0)
;
3 备份库
pg_dump -h localhost -p 5432 -U yuhui -F c -b -v -f yanglao.backup.sql yanglao
4 恢复库
pg_restore.exe -U yuhui -d yanglao yanglao.backup.sql