COPY FROM and INSERT INTO rules - Mailing list pgsql-general

From Sairam Krishnamurthy
Subject COPY FROM and INSERT INTO rules
Date
Msg-id 4CFD7F5F.3050301@gmail.com
Whole thread Raw
In response to Re: Do we want SYNONYMS?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: COPY FROM and INSERT INTO rules  (Vincent Veyron <vv.lists@wanadoo.fr>)
List pgsql-general
All,

I have a rule written on a temp table which will copy the values inserted into it to another table applying a function. The temp table will be discarded then. The rules I have written works when I use "Insert into" the temp table. But when I use bulk copy "COPY FROM", the rule doesn't get triggered and data is inserted only into the temp table that I created.

Is there a way to call a rule when I use "COPY FROM" instead of "INSERT INTO"

TIA,
Sairam

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Do we want SYNONYMS?
Next
From: "Daniel Verite"
Date:
Subject: Re: Do we want SYNONYMS?