Postgres Pro
Downloads
Home   >   mailing lists

How to view the SQL that Pg actually executes? - Mailing list pgsql-general

From Kynn Jones
Subject How to view the SQL that Pg actually executes?
Date
Msg-id c2350ba40710161043t172dca26t7c81fdb411ecaba4@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "jehan.procaccia"
Date:
Subject: move databases files location
Next
From: "Scott Marlowe"
Date:
Subject: Re: Updating a production database schema from dev server