Re: checking if sequence exists

From: Payal Singh <payal(at)omniti(dot)com>
To: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: checking if sequence exists
Date: 2013-11-15 19:38:50
Message-ID: CANUg7LBYTcJ34ijGDckUiENM-2UCd7PVSKbQu9ZWUxF9SVJy1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

\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(at)yahoo(dot)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...
> thanks
> tg
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thara Vadakkeveedu 2013-11-15 19:46:27 Re: checking if sequence exists
Previous Message Elliot 2013-11-15 19:36:31 Re: checking if sequence exists