且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何为pgAdmin III中的多个表生成CREATE脚本?

更新时间:2023-02-03 18:21:32

这是使用pgAdmin的一种方法.

  • 右键单击您的数据库(或架构).
  • 选择备份"
  • 在格式"下选择普通"
  • 在转储选项#1"下,选择仅架构"
  • 在对象"下选择所需的表.

然后单击备份".输出应该是带有创建表语句的纯文本文件.

此处是有关备份的PgAdmin文档.>

In pgAdmin III you can:

  • right-click a table;
  • scripts;
  • CREATE script;
  • save the script from the SQL Editor.

If one has to do this for more than one table, is there a way to combine the scripts in one file (apart from manually copy-pasting them)? If this can be done via psql prompt or phppgadmin, that will be ok too.

Here's a way using pgAdmin.

  • Right-click on your database (or schema).
  • Choose "backup"
  • Under "Format" choose "plain"
  • Under "Dump Options #1" choose "Only schema"
  • Under "Objects" choose the tables you want.

Then click "backup". The output should be a plain text file with the create table statements.

Here's the PgAdmin documentation on backup.