Re: Create DDL trigger to catch which column was altered

2018-07-10 Thread Łukasz Jarych
It is no possible? Jacek pon., 9 lip 2018 o 13:38 Łukasz Jarych napisał(a): > Hi Guys, > > i am using sqls like below to track ddl changes: > > CREATE TABLE track_ddl >> ( >> event text, >> command text, >> ddl_time timestamptz, >> usr text >> ); >> CREATE OR REPLACE FUNCTION

Create DDL trigger to catch which column was altered

2018-07-09 Thread Łukasz Jarych
Hi Guys, i am using sqls like below to track ddl changes: CREATE TABLE track_ddl > ( > event text, > command text, > ddl_time timestamptz, > usr text > ); > CREATE OR REPLACE FUNCTION track_ddl_function() > RETURNS event_trigger > AS > $$ > BEGIN > INSERT INTO track_ddl values(tg_tag,