Request a Demo
Home   >   mailing lists

Re: dynamic insert in plpgsql - Mailing list pgsql-general

From Merlin Moncure
Subject Re: dynamic insert in plpgsql
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: dynamic insert in plpgsql  (Dimitri Fontaine <[email protected]>)
Responses Re: dynamic insert in plpgsql
List pgsql-general
Tree view 
2010/1/9 Dimitri Fontaine <[email protected]>:
> Grzegorz Jaśkiewicz <[email protected]> writes:
>
>> Is there any nice way to do something like that in plpgsql:
>>
>>   EXECUTE 'INSERT INTO '||partition_table_name||' VALUES'||(NEW.*)||'';
>
> See http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers
> --

that approach is awful.  Sam's method (or the one I posted in the same
thread using dollar quoting) is much faster/better.

merlin

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Gentoo, 8,2 ---> 8.4, and /var/run/postgresql in mode 770
Next
From: [email protected]
Date:
Subject: Re: Gentoo, 8,2 ---> 8.4, and /var/run/postgresql in mode 770