postgresqlpsqlpgadminphppgadmin

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


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.


Solution

  • 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.