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