Re: COPY FROM and INSERT INTO rules

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Sairam Krishnamurthy <kmsram420(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY FROM and INSERT INTO rules
Date: 2010-12-07 11:48:48
Message-ID: 1291722528.2491.22.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message kobi.biton 2010-12-07 11:58:46 Re: if-clause to an exiting statement
Previous Message Allan Kamau 2010-12-07 11:37:18 Re: Copying entire tsv record (from file) into a single field