Skip site navigation (1) Skip section navigation (2)

Re: Suggested enhancement to pg_restore

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Michael Nolan <htfoot(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Suggested enhancement to pg_restore
Date: 2011-07-26 23:10:09
Message-ID: CAKt_Zft9B0nXDXqCr9KAOfL5iCTPHydgdRjNyL09kWxZiCA2wQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Jul 26, 2011 at 3:48 PM, Michael Nolan <htfoot(at)gmail(dot)com> wrote:
> I suggest adding the following parameter to pg_restore:
>
> --rename-table=XXXX
>
> When used in conjunction with the --data-only, --schema and -t options (all
> three of which would be necessary),
> it would allow restoring a table (without indexes) to a different table name
> (which would need to already exist
> and match the structure of the table which is being restored, of course.)

Does pg_restore allow you to specify a set of tables the same way
pg_dump does, i.e. by -t table1 -t table2?

If so how would this feature play along?

Best Wishes,
Chris Travers

In response to

Responses

pgsql-general by date

Next:From: Chris TraversDate: 2011-07-26 23:12:58
Subject: Re: 100 times faster than mysql
Previous:From: Greg SmithDate: 2011-07-26 22:53:55
Subject: Re: 100 times faster than mysql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group