On 04/02/2015 09:59 PM, Scott Ribe wrote:
> On Apr 2, 2015, at 10:14 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> EXECUTE 'insert into ' || quote_ident(tblname) || ' values(' || new.* || ')'
>
> Not that easy, strings are not quoted correctly, and null values are blank. Might be a function to translate new.*
intoa string as needed for this use, but I found another way based on Tom's suggestion:
My mistake for grabbing off the top of my head without testing my code.
>
> execute('insert into ' || tblnm || ' select $1.*') using new;
>
--
Adrian Klaver
adrian.klaver@aklaver.com