Re: What Would You Like To Do?

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