How to view the SQL that Pg actually executes?

From: "Kynn Jones" <kynnjo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to view the SQL that Pg actually executes?
Date: 2007-10-16 17:43:33
Message-ID: c2350ba40710161043t172dca26t7c81fdb411ecaba4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I understand that in some cases (e.g. when add_missing_from is true),
Pg will modifiy some SQL input before running it. Is there a way to
get Pg to print out the SQL it will actually execute? Is it possible
to get to *just* print out this SQL without actually executing it?

TIA!

kj

Browse pgsql-general by date

  From Date Subject
Next Message Aleksandrs Vinogradovs 2007-10-16 17:51:15 SPI_exec() + PG_TRY/PG_CATCH
Previous Message Thomas Kellerer 2007-10-16 17:16:45 Re: Preserving view source code