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.
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 |