How to generate a CREATE script for several tables in pgAdmin III?

pgadmin, phppgadmin, postgresql, psql

Solution

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.

Problem

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.

Original source