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
\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.
Payal Singh, OmniTi Computer Consulting Inc. Junior Database Architect, Phone: 240.646.0770 x 253
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...
