Setting rule on COPY command

From: dcpatel(at)hss(dot)hns(dot)com (D C Patel)
To: pgsql-general(at)postgresql(dot)org
Subject: Setting rule on COPY command
Date: 2003-02-04 11:26:01
Message-ID: 3bee17c5.0302040326.4be1be53@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have been copying the bulk amount of data from an ascii file to
database to avoid delay in individual insertion. However I couldn't
get any method to put a rule for inserting the row while copying, like
it happens when individual INSERT command is executed.One can apply a
rule for Insertion/Delete/Update. Is it possible to have the same kind
of Rule functionality for COPY, where a rule will be applicable for
individual row when more than 1 row is being copied from file to
database at a time ?
OR any other functionality equivalent to rule on individual INSERT ?
Thanks.
Deep

Browse pgsql-general by date

  From Date Subject
Next Message Damjan Pipan 2003-02-04 11:27:39 HELP NEEDED: Recreating DROP columns
Previous Message Damjan Pipan 2003-02-04 11:16:08 HELP NEEDED: Recreating DROP columns