pg_dump & pg_restore suggestion

Started by Pavlo Golubover 19 years ago2 messagesgeneral
Jump to latest
#1Pavlo Golub
pavlo.golub@cybertec.at

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

#2Alexandre Arruda
alepaes@aldeiadigital.com.br
In reply to: Pavlo Golub (#1)
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:

Show quoted text

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.