pg_dump, COPY and inheritance
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@pillette.com
Andrew Lazarus <andrew@pillette.com> writes:
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.
Well, then, that's where the data was in the source database. I can
assure you pg_dump has gotten this right for many years.
regards, tom lane