Re: How to drop all the sequences
От | Neil Conway |
---|---|
Тема | Re: How to drop all the sequences |
Дата | |
Msg-id | 1045809773.583.438.camel@tokyo обсуждение исходный текст |
Ответ на | How to drop all the sequences ("Arunachalam Jaisankar" <arun_jaisankar@yahoo.com>) |
Ответы |
Re: How to drop all the sequences
Re: How to drop all the sequences |
Список | pgsql-general |
On Thu, 2003-02-20 at 11:40, Arunachalam Jaisankar wrote: > I found sequences are not getting dropped when tables are dropped. SERIAL sequences should automatically be dropped with their corresponding table in PostgreSQL 7.3.0 and later. > It is too difficult to drop all sequences one by one manually. Is > there any command to drop all sequences in a database? No. You could try iterating through pg_class, picking out the sequence relations (relkind = 'S') in the right database, and then dropping the sequences that way. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления: