\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@xxxxxxxxx> 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