Re: Issue with copying data from a text file. - Mailing list pgsql-sql

From Paul Lambert
Subject Re: Issue with copying data from a text file.
Date
Msg-id 45FF4AA3.4060808@autoledgers.com.au
Whole thread Raw
In response to Re: Issue with copying data from a text file.  (Phillip Smith <phillip.smith@weatherbeeta.com.au>)
Responses Re: Issue with copying data from a text file.  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Phillip Smith
Date:
Subject: Re: Issue with copying data from a text file.
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Issue with copying data from a text file.