Re: checking if sequence exists
| От | Thara Vadakkeveedu |
|---|---|
| Тема | Re: checking if sequence exists |
| Дата | |
| Msg-id | 1384544787.83230.YahooMailNeo@web125002.mail.ne1.yahoo.com обсуждение исходный текст |
| Ответ на | Re: checking if sequence exists (Payal Singh <payal@omniti.com>) |
| Список | pgsql-admin |
The name of the sequence is hibernate_sequence. I already checked in the pg_class table under catalogs..
Thanks,
From: Payal Singh <payal@omniti.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Sent: Friday, November 15, 2013 2:38 PM
Subject: Re: [ADMIN] checking if sequence exists
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Sent: Friday, November 15, 2013 2:38 PM
Subject: Re: [ADMIN] checking if sequence exists
\d <schema_name>.<table_name> will show you columns, their types and the modifiers. If you look in the modifiers section, you will be able to see existing sequences.
On Fri, Nov 15, 2013 at 2:30 PM, Thara Vadakkeveedu <tharagv@yahoo.com> wrote:
How can we find out if a particular sequence exists ? The idea is to check if sequence first and if it does not exist then create it...the goal is to do this when we deploy the application war...thankstg
В списке pgsql-admin по дате отправления: