serv-bot 22 serv-bot 22 - 1 year ago 209
SQL Question

Export a CREATE script for a database from pgAdmin

Say I've created a database in pgAdmin, but I want to export a CREATE sql file.

How would I go about generating the dump?

Answer Source

To generate a sql script that will create the tables as they exist in a given database do:

pg_dump --schema-only --no-owner the_database > create_the_tables.sql

This will give you a bunch of create table statements. Just to see how portable it was I tried the above as follows:

bvm$ pg_dump -s --no-owner devdb | sqlite3 so_ans.db

And then:

bvm$ sqlite3 so_ans.db .schema
CREATE TABLE courses (
    id integer NOT NULL,
    name text,
    created_by integer,
    jc text

Kind of cool.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download