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