I do not know for certain that its in pg_dump format, not having dealt with it specificly before. I will examine the files more closely to look for COPY statements. If not in that format, what else could it be that could be shoved right into a postgresql database? In any case, would an associated file (schema type?) tell me the field name arrangements that the data files are loaded with? or if COPY statements are used, would they name the fields being targeted?
Thanks again.
On 8/25/06, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote:
On Wed, Aug 23, 2006 at 12:27:09PM -0700, barryc.ctr@xxxxxxxxx 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@xxxxxxxxx> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFE7tZDIB7bNG8LQkwRAmqwAJ0S3UU1Im2CXnZ7XZ3231JUukrHGACgjiNH
FK36quKQzA7vwwweFfqaYCE=
=WLfn
-----END PGP SIGNATURE-----
