| From: | Andrew Lazarus <andrew(at)pillette(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dump, COPY and inheritance |
| Date: | 2008-06-09 22:43:00 |
| Message-ID: | 803224989.20080609154300@pillette.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I was surprised to find out that in my pg_dumpall, inherited tables
(which have no extra columns) come out empty. All of the data are in
the base table. I was doing a dump to upgrade from 8.2 to 8.3, and
this means that I have to split the base table up by hand. (Constraint
exclusion on child tables is very useful in the domain.)
Shouldn't pg_dump do a (not yet implemented)
COPY ONLY basetable TO stdout ?
COPY ONLY childtable TO stdout ?
--
Sincerely,
Andrew Lazarus mailto:andrew(at)pillette(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| vCard.VCF | text/x-vcard | 378 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-06-09 22:59:46 | Re: pg_dump, COPY and inheritance |
| Previous Message | Craig Ringer | 2008-06-09 17:09:55 | Re: fitler database list |