Обсуждение: pg_dump & pg_restore suggestion

Поиск
Список
Период
Сортировка

pg_dump & pg_restore suggestion

От
Pavel Golub
Дата:
Hello, pgsql-general.

Is it possible to create not only executable version of pg_dump and
pg_restore, but also libraries (.so, .dll) so developers can use them
freely the same as libpq client library?

I suppose it would be very usefull. For me it's for sure.

--
With best wishes,
 Pavel                          mailto:pavel@microolap.com


Re: pg_dump & pg_restore suggestion

От
Alexandre Arruda
Дата:
Hi,

My wishlist for pg_{dump,restore} have only 1 item:

1) Thats "pg_restore -t <table> file.bkp" returns not only the table,
but the related PK and indexes, like "pg_dump -t <table> <database">
makes with a operational database.
If you drop a table from a database, this drops whole table and,
obviously, your indexes. If you want to restore one table from a file,
you have previously to know what the indexes and PK the table have and
restore each manually.

Thanks,

Alexandre

Pavel Golub wrote:
> Hello, pgsql-general.
>
> Is it possible to create not only executable version of pg_dump and
> pg_restore, but also libraries (.so, .dll) so developers can use them
> freely the same as libpq client library?
>
> I suppose it would be very usefull. For me it's for sure.
>