DDL / DML question
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
"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