update/insert data

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: update/insert data
Date: 2004-11-27 17:55:40
Message-ID: 20041127175540.M63399@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I have two tables in different schemas. The first table in the data_transfer
schema is loaded with a COPY command. I need to transfer the data to the
second schema inserting new records and updating existing records. What is
the best way to achieve this functionality?

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kretschmer Andreas 2004-11-28 13:45:58 Re: [despammed] update/insert data
Previous Message Andrew Thorley 2004-11-27 15:33:30 Re: Type Inheritance