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

2006-08-26 Thread consultmac2
Peter Eisentraut wrote: Am Freitag, 25. August 2006 13:51 schrieb Martijn van Oosterhout: It really depends on the format they send you. It's either plain text, in which case the COPY commands will tell you which fields. If it's the custom format you can use tar to extract it IIRC. You

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

2006-08-26 Thread barry conner
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

[GENERAL] Can I read data load files without loading in db?

2006-08-25 Thread barryc . ctr
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

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

2006-08-25 Thread Martijn van Oosterhout
On Wed, Aug 23, 2006 at 12:27:09PM -0700, [EMAIL PROTECTED] 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

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

2006-08-25 Thread Martijn van Oosterhout
On Fri, Aug 25, 2006 at 07:36:38AM -0400, barry conner wrote: 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

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

2006-08-25 Thread Peter Eisentraut
Am Freitag, 25. August 2006 13:51 schrieb Martijn van Oosterhout: It really depends on the format they send you. It's either plain text, in which case the COPY commands will tell you which fields. If it's the custom format you can use tar to extract it IIRC. You can also use pg_restore to