CODEWITHSUNDEEP
postgresqlpsqlpgadminphppgadmin
Alexander Popov
Alexander Popov

Reputation: 25005

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.

Upvotes: 18

Views: 58167

Answers (2)

mlinth
mlinth

Reputation: 3128

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.

Upvotes: 39

OverworkedTechydude
OverworkedTechydude

Reputation: 271

"pg_dump" is also an option here. The -s flag for schema-only and -t to select specific tables. It's not psql or pgAdmin though. It's a utility available to the PostgreSQL user. Example:

sudo su - postgres
pg_dump -s database

Upvotes: 7

Related Questions