更新时间:2023-02-03 18:21:32
这是使用pgAdmin的一种方法.
然后单击备份".输出应该是带有创建表语句的纯文本文件.
此处是有关备份的PgAdmin文档.>
In pgAdmin III you can:
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.
Then click "backup". The output should be a plain text file with the create table statements.
Here's the PgAdmin documentation on backup.