From: Paul Lambert <paul.lambert@autoledgers.com.au>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: Issue with copying data from a text file.
Date: Tue, 20 Mar 2007 11:44:51 +0900
Message-ID: <45FF4AA3.4060808@autoledgers.com.au> (raw)
In-Reply-To: <1174358236.10466.14.camel@it-laptop>
References: <45FF4622.2010404@autoledgers.com.au>
<1174358236.10466.14.camel@it-laptop>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: paul.lambert@autoledgers.com.au, phillip.smith@weatherbeeta.com.au
Subject: Re: Issue with copying data from a text file.
In-Reply-To: <45FF4AA3.4060808@autoledgers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox