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
|
- Re: [SQL] Copy Command Error Richard Sydney-Smith
- Re: [SQL] Copy Command Error Richard Huxton