Re: pg_dump & pg_restore suggestion

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.
>