On 04/02/2015 08:30 PM, Scott Ribe wrote:
Easier to give an example than describe the question, any chance of making something like this work?
You doing this in plpgsql trigger function I presume?
execute('insert into ' || tblname || ' values(new.*)');
So
http://www.postgresql.org/docs/9.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN:
EXECUTE 'insert into ' || quote_ident(tblname) || ' values(' || new.* || ')'
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
