Re: [GENERAL] Copy command and duplicate items (Support Replace?)

[Decibel!]

On Tue, Aug 14, 2007 at 10:50:33AM +0800, Ow Mun Heng wrote:
> Hi,
> 
> Writing a script to pull data from SQL server into a flat-file (or just
> piped in directly to PG using Perl DBI)
> 
> Just wondering if the copy command is able to do a replace if there are
> existing data in the Db already. (This is usually in the case of updates
> to specific rows and there be a timestamp indicating it has been changed
> etc.)
> 
> In MySQL, the mysqlimport util has the --replace function which will
> replace the data if there is any event of a duplicate.
> 
> Does PG support this?

No; you'll need to COPY into a temporary or staging table and then
proceed from there. Alternatively, you could use
http://pgfoundry.org/projects/pgloader/.
-- 
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)


pgpyQNuNDvD9l.pgp
Description: PGP signature

[GENERAL] Copy command and duplicate items (Support Replace?)

[Ow Mun Heng]

Hi,

Writing a script to pull data from SQL server into a flat-file (or just
piped in directly to PG using Perl DBI)

Just wondering if the copy command is able to do a replace if there are
existing data in the Db already. (This is usually in the case of updates
to specific rows and there be a timestamp indicating it has been changed
etc.)

In MySQL, the mysqlimport util has the --replace function which will
replace the data if there is any event of a duplicate.

Does PG support this?



---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/