Re: nextval, sequences and sequencenames

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: nextval, sequences and sequencenames
Date: 2001-08-15 02:02:03
Message-ID: 9lcl6q$1908$3@node21.cwnet.roc.gblx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

> My question:
> is there anyway of retreiving the sequence_name corresponding to the
> respective column,
> knowing just the tablename and columnname?
>
> The reason I need to do this, is because the application I write
> dynamicly creates new tables, and I have no way of knowing the sequence
> name before hand.
>

If it is very difficult finding that sequence name (I'm not sure)
You may want to create the sequence yourself instead of using SERIAL.
Then you would know the name.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2001-08-15 02:14:02 Re: nextval, sequences and sequencenames
Previous Message Stephan Szabo 2001-08-15 01:30:34 Re: Null Conversion

Browse pgsql-novice by date

  From Date Subject
Next Message Chris 2001-08-15 02:14:02 Re: nextval, sequences and sequencenames
Previous Message Colin Bussanich 2001-08-14 16:50:58 Problems running configure on Solaris.