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

Thanks for your reply Martijn.
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(at)svana(dot)org> wrote:
>
> 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.
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
>
> iD8DBQFE7tZDIB7bNG8LQkwRAmqwAJ0S3UU1Im2CXnZ7XZ3231JUukrHGACgjiNH
> FK36quKQzA7vwwweFfqaYCE=
> =WLfn
> -----END PGP SIGNATURE-----
>
>
>