plpgsql: copy all columns inside a trigger

From: Andreas Scherbaum <adsmail(at)htl(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql: copy all columns inside a trigger
Date: 2002-03-20 12:01:33
Message-ID: 3C987A1D.616999C1@htl.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i got a little problem:

I have a trigger fired up after insert and want to copy all colums
from NEW into another table (without knowing the exact column
names, but the target table also contains the same column names).
Is it possible to create the appropriate query in plpgsql?
The reason for this procedure is: i want to use the same trigger
for more tables and be flexible without creating a single
trigger for every new table.

Any hints?

Best regards

--
Andreas 'ads' Scherbaum

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2002-03-20 12:05:36 Distributed databases and replication in postgresql 7.3 ?
Previous Message TPCCUVA 2002-03-20 10:34:17 CHECKPOINTS.