Re: Issue with copying data from a text file. - Mailing list 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