Re: [pgadmin-support] Accessing SQL that has been executed behind the interface

2015-12-01 Thread Melvin Davidson
>>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 captu

Re: [pgadmin-support] Accessing SQL that has been executed behind the interface

2015-12-01 Thread Wizz
That's exactly what I was looking for. I had no idea there was an SQL tab. Perfect, thank you! -- View this message in context: http://postgresql.nabble.com/Accessing-SQL-that-has-been-executed-behind-the-interface-tp5875650p5875656.html Sent from the PostgreSQL - pgadmin support mailing list a

Re: [pgadmin-support] Accessing SQL that has been executed behind the interface

2015-12-01 Thread Dave Page
Hi On Tue, Dec 1, 2015 at 12:41 PM, Wizz 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