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
Ответ на
Список
Дерево обсуждения
Issue with copying data from a text file. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Issue with copying data from a text file. Phillip Smith <phillip.smith@weatherbeeta.com.au>
Re: Issue with copying data from a text file. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Issue with copying data from a text file. "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: Issue with copying data from a text file. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Issue with copying data from a text file. Phillip Smith <phillip.smith@weatherbeeta.com.au>
Re: Issue with copying data from a text file. Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Issue with copying data from a text file. Michael Fuhr <mike@fuhr.org>
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
Дата:
От: Michael Fuhr
Дата:
FAQ