Simon Riggs <simon@2ndQuadrant.com> writes:
> On 5 December 2012 15:01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> And perhaps more to the point, what's the advantage compared to
>> good old "log_statement = ddl"?
> That logs DDL statements for the whole system and isn't user settable.
Not true; you can set it with ALTER ROLE/DATABASE, and a superuser can
adjust it for his own session.
> * pg_stat_ddl (from Dimitri) which would be a temp table containing results
> * Stream of NOTICE statements back to client.... that seems easier
> * err...
And an ORM is going to do what with either, pray tell? None of these
are of any use except with an interactive session; in which the user
could perfectly well use EXPLAIN, anyway.
regards, tom lane
