Re: Immodest Proposal: pg_catalog.pg_ddl

Tom Lane wrote:

>
>>Simple. Postmaster logs can roll over or otherwise be lost without
>>damaging the DB. This would provide a non-volatile log of DDLs.
>>
>>
>
>In that case you have to provide a pretty strong argument why everyone
>should be forced to have a non-volatile log of DDLs.
>
>

Conversely, why *only* DDL. As soon as we had this there would be a very
strong demand to log DML.

Maybe we need an optional asynch logging process as yet another member
of our growing band of specialist background processes.

What I would like to see is some builtin functions that give me the
table's DDL, just as pg_dump does. Extra nice would be complementary
functions that also give me skeleton select statements for each table or
view. I used to use such facilities a lot in years gone by, along with
c&p - maybe I'm just old-fashioned.

cheers

andrew