Re: Issue with copying data from a text file.

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Issue with copying data from a text file.
Дата
Msg-id 45FF5349.1020406@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Issue with copying data from a text file.  (Phillip Smith <phillip.smith@weatherbeeta.com.au>)
Список pgsql-sql
Phillip Smith wrote:
> Maybe use char 254 or 253 or something similar... Anything that isn't 
> going to be found in the file.
> 
> Have you tried using a string as a delimiter? QUOTE 
> 'THIS.STRING.ISNT.IN.THE.TEXT.FILE'
> 
> ~p
> 

I changed it to QUOTE '\f' to set the quote character to form-feed which 
is not going to appear in the file and that appears to do the trick 
without any changes to the source file.

Thanks,
P.

-- 
Paul Lambert
Database Administrator
AutoLedgers


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Issue with copying data from a text file.
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: How to declare cursor if tablename is a variable?