Copy Command Error

From: "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Copy Command Error
Date: 2003-09-15 08:57:07
Message-ID: 001601c37b67$608235e0$dd6d32d2@athlon2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-09-15 10:01:24 Re: Copy Command Error
Previous Message Richard Huxton 2003-09-15 08:33:38 Re: Plz, what is the most "correct" method