"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)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