Re: Backup and restore sequences

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(dot)klaver(at)gmail(dot)com