Copy Command Error

Поиск

Список

Период

Сортировка

От	Richard Sydney-Smith
Тема	Copy Command Error
Дата	15 сентября 2003 г. 05:55:28
Msg-id	001601c37b67$608235e0$dd6d32d2@athlon2000 обсуждение исходный текст
Ответы	Re: Copy Command Error
Список	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

В списке pgsql-sql по дате отправления: