Postgresql导出指定的数据表

两对双引号"\"\""是用于解决:pg_dump: no matching tables were found 问题。

pg_dump -h localhost -p 5432 -U postgres -d mydb -t "\"demoTable1\"" -t "\"demoTable2\"" > D:\\backup.sql

posted @ 2017-04-18 17:21  Waichung  阅读(2512)  评论(0编辑  收藏  举报