On 09/13/2011 11:51 AM, Michael Nolan wrote:
The ability to restore a table from a backup file to a different
table
name in the same database and schema.
This can be done but agreed it is not intuitive.
Can you elaborate on tha a bit, please? The only way I've been able to
do it is to edit the dump file to change the table name. That's not
very practical with a several gigabyte dump file, even less so with one
that is much larger. If this capability already exists, is it documented?
You use the -Fc method, extract the TOC and edit just the TOC (so you
don't have to edit a multi-gig file)
(SqlPlus has this, even though it isn't very pretty.)
A built-in report writer, capable of things like column totals.
There are a billion and one tools that do this without us having to
reinvent the wheel. Why would we support that?
There are other databases out there, too, why reinvent the wheel by
working on PostgreSQL? :-)
The question shoud be, would this be USEFUL?
Personally, I don't think so but others may disagree.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
