Re: Backup and restore sequences

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Backup and restore sequences
Дата
Msg-id 4D275D49.5020805@gmail.com
обсуждение исходный текст
Ответ на Backup and restore sequences  (gvim <gvimrc@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: OOO and postgres
Следующее
От: "Bob Pawley"
Дата:
Сообщение: Remote Connection