Re: DDL / DML question - Mailing list pgsql-general

"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