Re: dynamic insert in plpgsql

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dynamic insert in plpgsql
Date: 2010-01-09 21:50:53
Message-ID: m2vdfbosle.fsf@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> 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
--
dim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-01-09 21:57:47 Re: Gentoo, 8,2 ---> 8.4, and /var/run/postgresql in mode 770
Previous Message Andreas Kretschmer 2010-01-09 21:46:44 Re: An issue with max() and order by ... limit 1 in postgresql8.3-beta3