| 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: | Whole Thread | Raw Message | 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 |