Re: Issue with copying data from a text file.

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Issue with copying data from a text file.
Date: 2007-03-20 03:21:45
Message-ID: 45FF5349.1020406@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2007-03-20 03:41:11 Re: How to declare cursor if tablename is a variable?
Previous Message Michael Fuhr 2007-03-20 03:17:00 Re: Issue with copying data from a text file.