DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=MVXMMy2IkRFmx7j09rB9IWkLpqzxzs7xOqY3D3j3lHXpXE1vKSqjlut7KvDFWcARCkwt4uLFYPQmRuDMGa5Euty3rjQNNk21BlAusfhtFgBoxaNKZw6Nfosi8CI1jyxZfHJz3UOiunAXLx+LTxgByo8tNACNYXJ7mKggJ9CRags=
Message-ID: <b35603930703191953g73e0e28bl3012e7b6836ba780@mail.gmail.com>
Date: Tue, 20 Mar 2007 14:53:04 +1200
From: "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
To: "Paul Lambert" <paul.lambert@autoledgers.com.au>
Subject: Re: Issue with copying data from a text file.
Cc: "Phillip Smith" <phillip.smith@weatherbeeta.com.au>,
	pgsql-sql@postgresql.org
In-Reply-To: <45FF4AA3.4060808@autoledgers.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <45FF4622.2010404@autoledgers.com.au>
	<1174358236.10466.14.camel@it-laptop>
	<45FF4AA3.4060808@autoledgers.com.au>

On 3/20/07, Paul Lambert <paul.lambert@autoledgers.com.au> wrote:

> 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.
Pipe it through sed and replace the Carets with TABS?
sed 's/^/\t/g' c:/temp/autodrs_deal_lines.txt > c:/temp/autodrs_deal_lines.tab

Then use copy like so:
\copy table from 'c:/temp/autodrs_deal_lines.tab' delimiter E'\t' null ''


Cheers,
Andrej