From: Richard Sydney-Smith <richard@ibisaustralia.com>
To: pgsql-sql@postgresql.org
Subject: Copy Command Error
Date: Mon, 15 Sep 2003 16:57:07 +0800
Message-ID: <001601c37b67$608235e0$dd6d32d2@athlon2000> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richard@ibisaustralia.com
Subject: Re: Copy Command Error
In-Reply-To: <001601c37b67$608235e0$dd6d32d2@athlon2000>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox