Postgres Pro
Downloads
Home   >   mailing lists

update/insert data - Mailing list pgsql-sql

From Keith Worthington
Subject update/insert data
Date
Msg-id 20041127175540.M63399@narrowpathinc.com
Whole thread Raw
Responses Re: [despammed] update/insert data
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: m
Date:
Subject: Re: Querying a list field against another list
Next
From: Kretschmer Andreas
Date:
Subject: Re: [despammed] update/insert data