Re: Accessing SQL that has been executed behind the interface - Mailing list pgadmin-support
>>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 in
postgresql.conf to ddl
IE:
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 table
B. 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
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@gmail.com>
To: pgadmin-support@postgresql.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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
pgadmin-support by date: