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

From Vincent Veyron
Subject Re: COPY FROM and INSERT INTO rules
Date
Msg-id 1291722528.2491.22.camel@asus-1001PX.home
Whole thread Raw
In response to COPY FROM and INSERT INTO rules  (Sairam Krishnamurthy <kmsram420@gmail.com>)
List pgsql-general
Le lundi 06 décembre 2010 à 18:27 -0600, Sairam Krishnamurthy a écrit :

You should start a new thread for this


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

from the doc :

COPY FROM will invoke any triggers and check constraints on the
destination table. However, it will not invoke rules.

http://www.postgresql.org/docs/9.0/static/sql-copy.html

--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service juridique


pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Re: Copying entire tsv record (from file) into a single field
Next
From: "Daniel Verite"
Date:
Subject: Re: Do we want SYNONYMS?