Re: Feature request: pgdump and version number / -i option

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: Friday, January 09, 2009 1:39 PM
> To: Laurent ROCHE
> Cc: pgAdmin III support
> Subject: Re: [pgadmin-support] Feature request: pgdump and
> version number / -i option
>
>
> On Thu, Jan 8, 2009 at 4:05 PM, Laurent ROCHE
> <laurent_roche(at)yahoo(dot)com> wrote:
>
> > But in a future version, could we have an extra option in
> the backup
> > popup to use the -i option ?
>
> This keeps coming back to haunt me in :-(. I've added an
> option - hopefully that'll keep everyone happy!

Can we get the database to handle this instead / also?

If pg_dump / pg_restore were libs, could this be called via pl/pgsql
functions instead?

SELECT PG_DUMP(database text,schema text, filename text,
compressiontype text, other options...)
SELECT PG_RESTORE(database text,schema text, filename text)

This would not be useable for client side dumps of the database. But in
those cases pg_dump could still be used, or the dump location
exported/shared.

This would also require the dump location to be writeable by the server
process (postgres user).

>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>
> --
> Sent via pgadmin-support mailing list
> (pgadmin-support(at)postgresql(dot)org) To make changes to your
> subscription: http://www.postgresql.org/mailpref/pgadmin-support
>