Thread: DDL / DML question

DDL / DML question

From
"Johnson, Shaunn"
Date:

Howdy:

Running PostgreSQL 7.1.3 (soon to be 7.2.1) on RedHat Linux
7.2.

I've been asked to generate a list of all DDL and DML
statements.  (We are testing a few environments and
DB2 UDB and Oracle 9 are some of the other databases).

I am looking at some (old) notes in the newsgroup and I see
'pg_dump -S <database>' as an answer, but this doesn't seem to
be right.  The man pages says that all -S does is specify the
superuser when disabling triggers and setting ownership.

Any suggestions?  Thanks!

-X

Re: DDL / DML question

From
Tom Lane
Date:
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> I've been asked to generate a list of all DDL and DML
> statements.  (We are testing a few environments and
> DB2 UDB and Oracle 9 are some of the other databases).

> I am looking at some (old) notes in the newsgroup and I see
> 'pg_dump -S <database>' as an answer, but this doesn't seem to
> be right.

I think what you are looking for is "pg_dump -s" (schema-only dump).

            regards, tom lane