Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE RULE _copy AS ON COPY TO ... - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: CREATE RULE _copy AS ON COPY TO ...
Date
Msg-id CEF41C37-C0D9-457F-B639-D9BA99E43645@enterprisedb.com
Whole thread Raw
In response to CREATE RULE _copy AS ON COPY TO ...  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Tree view 
On Apr 11, 2011, at 11:56 PM, Willy-Bas Loos wrote:

> My ON INSERT rule won't go off when I copy into it.
> Is there a way to COPY into a RULE?

COPY Command does not respect rule on table, so please use trigger.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Howto use "COPY FROM" with the native API?
Next
From: Joel Stevenson
Date:
Subject: Column storage (EXTERNAL/EXTENDED) settings for bytea/text column