Message-ID: <45FF4AA3.4060808@autoledgers.com.au>
Date: Tue, 20 Mar 2007 11:44:51 +0900
From: Paul Lambert <paul.lambert@autoledgers.com.au>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>,
	pgsql-sql@postgresql.org
Subject: Re: Issue with copying data from a text file.
References: <45FF4622.2010404@autoledgers.com.au>
	<1174358236.10466.14.camel@it-laptop>
In-Reply-To: <1174358236.10466.14.camel@it-laptop>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Phillip Smith wrote:
> Can you not export the source file with escape characters? ie,
> 
> ^17\" Alloy Wheels^
> 
> ~p
> 

The source file comes from extracts on our main application which sits 
inside an in-house pretending-to-be-a-dbms file system. The content of 
these extracts would be difficult to change - the extract program would 
need to parse the data looking for quotes and preceed them with the 
necessary escape character.

Not being a proper database dump it's not a simple matter of flicking a 
switch to get it to include the escape character. The way the extracts 
are written would require a few dozen lines of code to each extract, and 
theres about 40ish extracts.

Plus I don't maintain that side of our code, and those that do can be a 
bit lazy and I'd likely be waiting months to get it done - if they even 
decide to do it.

-- 
Paul Lambert
Database Administrator
AutoLedgers