Re: Backup and restore sequences - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Backup and restore sequences
Date
Msg-id 4D275D49.5020805@gmail.com
Whole thread Raw
In response to Backup and restore sequences  (gvim <gvimrc@gmail.com>)
List pgsql-general
On 01/07/2011 08:26 AM, gvim wrote:
> On 07/01/2011 15:58, Adrian Klaver wrote:
>>
>> Details below. When you dump a specific table using -t it will not
>> automatically dump dependent objects. -t can be used to dump a
>> sequence because
>> they are just a special type of table.
>>
>> From:
>> http://www.postgresql.org/docs/9.0/interactive/app-pgdump.html
>> "
>> -t table
>> --table=table
>>
>
> Thanks. I just found this and it works great but wish pgAdmin had
> something similar.
>
> gvim


I broke down and installed pgAdmin. You can do what you want by finding
the sequence in the object browser on the left and right clicking and
selecting CREATE script.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: OOO and postgres
Next
From: "Bob Pawley"
Date:
Subject: Remote Connection