Re: quick q re execute & scope of new - Mailing list pgsql-general

From Adrian Klaver
Subject Re: quick q re execute & scope of new
Date
Msg-id 551E1396.5040809@aklaver.com
Whole thread Raw
In response to quick q re execute & scope of new  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: quick q re execute & scope of new
List pgsql-general
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@aklaver.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: quick q re execute & scope of new
Next
From: Scott Ribe
Date:
Subject: Re: quick q re execute & scope of new