Re: Can I read data load files without loading in db?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: barryc(dot)ctr(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can I read data load files without loading in db?
Date: 2006-08-25 10:51:47
Message-ID: 20060825105147.GE16535@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 23, 2006 at 12:27:09PM -0700, barryc(dot)ctr(at)gmail(dot)com wrote:
> We have an awkward situation.
>
> An affiliate organization periodically sends us a stack of CDs. On
> the first one there are a couple of small scripts to handle installing
> the data and/or upgrading the database schema. Most of the CD's
> contents are large data files to be used to update a postgresql
> database.

I assume from the question that the data is in pg_dump format? i.e. a
whole pile of COPY statements with data?

In that case just write a perl script to extract the data.

Or specify more precisely if that's not the problem.

Have anice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message barry conner 2006-08-25 11:36:38 Re: Can I read data load files without loading in db?
Previous Message Mark Matthews 2006-08-25 10:33:32 Re: CMS - portal server Question