| From: | Chris Travers <chris(at)metatrontech(dot)com> |
|---|---|
| To: | jvilla(at)innovativesource(dot)net |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrading from 7.1 |
| Date: | 2005-07-28 03:49:51 |
| Message-ID: | 42E855DF.7050305@metatrontech.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All;
Actually, as I am remembering how I worked through this problem...
I ended up withh a simple shell script something like:
#!/bin/bash
dumpfile="dump.pgsql"
pg_dump -s dbname > $dumpfile
for a in table1 table2 table3 table4 table5 table5 table6
do
pg_dump -a -t $a >> $dumpfile
done
Hope this helps,
Chris Travers
Metatron Technology Consulting
| Attachment | Content-Type | Size |
|---|---|---|
| chris.vcf | text/x-vcard | 127 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan 'Kaishakunin' Schumacher | 2005-07-28 03:55:32 | Re: GUID for postgreSQL |
| Previous Message | Joshua D. Drake | 2005-07-28 03:34:56 | Re: MySQL to PostgreSQL, was ENUM type |