Re: Accessing SQL that has been executed behind the interface

>>How can I access the SQL that executes when I
>>alter my tables...
There are two ways, the first is the change to uncomment and change the value of log_statement inpostgresql.conf to ddlIE:
log_statement = 'ddl'
Then you must do a reload of the postgresql.conf.ddl statements will then be captured to the log.

The other way is to make the changes to the table in properties.A. right click on the tableB. left click on Properties...C. Add column, constraints, etc as needed.D. Click on the SQL tab _BEFORE_ clicking the OK button,
 Melvin Davidson
    Cell 720-320-0155

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

www.youtube.com/unusedhero

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

From: Wizz <mastuh8(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Sent: Tuesday, December 1, 2015 7:41 AM
Subject: [pgadmin-support] Accessing SQL that has been executed behind the interface

How can I access the SQL that executes when I alter my tables with the
pgAdmin interface.
For instance, if I add a column, without a doubt, there was a "ALTER TABLE
tablename ADD COLUMN column name int;" executed in the background. How do I
get to it?
I need to make a bunch of changes to a database and then have those changes
in the form of SQL so I can pass it on to a colleague, who will execute it
on an identical database.
Thank you!

--
View this message in context: http://postgresql.nabble.com/Accessing-SQL-that-has-been-executed-behind-the-interface-tp5875650.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.