cmd到PostgreSQL安装目录bin下:
备份数据库:
pg_dump -h localhost -U root test> C:\test.bak
如上命令,
pg_dump 是备份数据库指令;
localhost是数据库的ip地址;
root是数据库的用户名;
test是数据库名;
最后导出到指定目录;
恢复数据库:
psql -h localhost -U root -d test< C:\test.bak
备份表:
pg_dump -h localhost -U root test-t books > C:\books.bak
恢复表:
psql -h localhost -U root -d test-t books < C:\books.bak