| 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: | Whole Thread | Raw Message | 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
| 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 |