log_statement='ddl'
이렇게 세팅하면 DDL 문만 아래처럼 서버로그에 로깅 됩니다.
2014-12-19 02:41:08 KST myuser testdb [6515, 549311ae.1973]LOG: statement: create table x(x int);
2014-12-19 02:41:08 KST myuser testdb [6515, 549311ae.1973]ERROR: relation "x" already exists
2014-12-19 02:41:08 KST myuser testdb [6515, 549311ae.1973]STATEMENT: create table x(x int);
2014-12-19 02:41:10 KST myuser testdb [6515, 549311ae.1973]LOG: statement: drop table x;