Re: CSV-bulk import and defaults

From: Andrej <andrej(dot)groups(at)gmail(dot)com>
To: Thomas Schmidt <postgres(at)stephan(dot)homeunix(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CSV-bulk import and defaults
Date: 2011-01-03 20:39:21
Message-ID: AANLkTinwdupxw8Shhn2Tm1sLiXqzt=+5tKckbqRjXsbY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3 January 2011 11:22, Thomas Schmidt <postgres(at)stephan(dot)homeunix(dot)net> wrote:
> Thus - do you have any clue on designing an fast bulk-import for staging
> data?

As you're talking about STDIN ... have you considered
piping the input-data through awk or sed to achieve a
pre-populated empty meta data field? Easy enough,
low CPU overhead.

> Thanks in advance,
> Thomas

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.georgedillon.com/web/html_email_is_evil.shtml

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2011-01-03 20:39:47 Re: WAL Archiving Stopped
Previous Message Vincent Veyron 2011-01-03 20:21:30 Re: problem updating from form