Re: pg_dump & pg_restore suggestion

From: Alexandre Arruda <alepaes(at)aldeiadigital(dot)com(dot)br>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump & pg_restore suggestion
Date: 2006-07-24 20:57:14
Message-ID: 44C5342A.7000103@aldeiadigital.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schoenebeck 2006-07-24 21:27:57 CASE statement and SETOF values
Previous Message Tom Lane 2006-07-24 20:54:24 Re: gmake Errors: pg_backup_archiver.c: undefined reference to `lo_create'