Re: Simpler dump? - Mailing list pgsql-general

From Tom Lane
Subject Re: Simpler dump?
Date
Msg-id 27447.1197265699@sss.pgh.pa.us
Whole thread Raw
In response to Simpler dump?  (Ted Byers <r.ted.byers@rogers.com>)
Responses Re: Simpler dump?
List pgsql-general
Ted Byers <r.ted.byers@rogers.com> writes:
> Is there a way to tell pg_dump to just dump the SQL
> statements required to create the tables, sequences,
> indeces, keys, &c.?

pg_dump -s ?

> I DON'T need to restore or
> recreate things like users, or most other kinds of DB
> objects.  Just routine DDL statements.

pg_dump doesn't try to recreate users, and to most people "DDL" would
include the creation commands for any type of DB object whatsoever.
Your demarcation between stuff you want and stuff you don't seems far
too vaguely stated.

            regards, tom lane

pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: Simpler dump?
Next
From: Richard Huxton
Date:
Subject: Re: Pg_catalog reference