pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Paul Lambert <paul.lambert@autoledgers.com.au>
To: Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Issue with copying data from a text file.
Date: Tue, 20 Mar 2007 11:59:06 +0900
Message-ID: <45FF4DFA.1020202@autoledgers.com.au> (raw)
In-Reply-To: <b35603930703191953g73e0e28bl3012e7b6836ba780@mail.gmail.com>
References: <45FF4622.2010404@autoledgers.com.au>
	<1174358236.10466.14.camel@it-laptop>
	<45FF4AA3.4060808@autoledgers.com.au>
	<b35603930703191953g73e0e28bl3012e7b6836ba780@mail.gmail.com>

Andrej Ricnik-Bay wrote:
> 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
> 
> 

The data contains tabs... don't ask why... I don't have a clue :P

I'll do something along the lines of sed... but not with sed, I'll use 
the command line interpreter on the OpenVMS systems where the extracts 
run. I just thought there might have been a quicker way to switch it off 
in the copy command, i.e. specifying "quote none" as one of the 
parameters to the command. I guess not...

Thanks for the pointers.

P.

-- 
Paul Lambert
Database Administrator
AutoLedgers

view thread (9+ messages)  latest in thread

Message-ID: <45FF4DFA.1020202@autoledgers.com.au>
Permalink:  ../45FF4DFA.1020202@autoledgers.com.au/
Also on:    postgresql.org/message-id/45FF4DFA.1020202@autoledgers.com.au

copy link · copy postgr.es

reply

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, andrej.groups@gmail.com, phillip.smith@weatherbeeta.com.au
  Subject: Re: Issue with copying data from a text file.
  In-Reply-To: <45FF4DFA.1020202@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