PgSQL数据库运维操作

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