Re: Accessing SQL that has been executed behind the interface

Hi

On Tue, Dec 1, 2015 at 12:41 PM, Wizz <mastuh8(at)gmail(dot)com> wrote:
> 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!

You can either:

- Turn up the log level to include SQL, and extract the statements
from the log (though that can be a pain as there's a lot of additional
stuff there), or;

- Click on the SQL tab on each dialogue you make changes in, before
you hit OK. That'll show you the SQL that will be executed by the
changes you've made in the dialogue.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company