postgresql pgAdmin III 恢复 PLAIN 备份

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4889610/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-10 22:49:20  来源:igfitidea点击:

pgAdmin III Restore PLAIN Backup

postgresql

提问by Nick Binnet

New to PostgreSQL database, I found column names were automatically converted to lowercase. I created a PLAIN backup, manually edited the column names to proper case. When I tried to restore the edited PLAIN backup, the OK button of pgAdmin3 Restore was disabled.

PostgreSQL 数据库的新手,我发现列名会自动转换为小写。我创建了一个 PLAIN 备份,手动将列名编辑为正确的大小写。当我尝试恢复编辑后的 ​​PLAIN 备份时,pgAdmin3 Restore 的 OK 按钮被禁用。

Is there a way run the edited plain backup file? Please help.

有没有办法运行编辑后的纯备份文件?请帮忙。

回答by Frank Heikens

Use the client program psqlto restore, works fine. The installers of pgAdmin and PostgreSQL also install psql, so you should have it on your pc or your database server.

使用客户端程序psql恢复,正常。pgAdmin 和 PostgreSQL 的安装程序也会安装 psql,所以你应该在你的电脑或数据库服务器上安装它。

psql -f backup.sql postgres