Home > mailing lists

Copy Command Error - Mailing list pgsql-sql

From	Richard Sydney-Smith
Subject	Copy Command Error
Date	September 15, 2003 08:55:28
Msg-id	001601c37b67$608235e0$dd6d32d2@athlon2000 Whole thread Raw
Responses	Re: Copy Command Error (Richard Huxton <dev@archonet.com>)
List	pgsql-sql

I am outputting the following rows from a SYBASE database on W2000

3 '2' 'IBISFinancials' 'A.C.N. 072 378 815'
8 'RK' 'Personal Accounts'

Using the command:

select cast(seq as integer) , id , cmpy, tr_n from fcont; output to d:\fcont.dat format 'ascii' delimited by '\x09'

This outputs the fields tab delimited and with strings encased in inverted commas

I then use the followin POSTRESQL command:

copy fcont (seq,id,cmpy,tr_n) from 'd:\\fcont.dat'

The problem is that each string is imported with the inverted commas.

eg field ID = ''RK'' instead of 'RK'

Can someone please help?

thanks

Richard

From: Richard Huxton
Date: 15 September 2003, 08:34:20
Subject: Re: Plz, what is the most "correct" method

From: Richard Huxton
Date: 15 September 2003, 10:02:23
Subject: Re: Copy Command Error