Re: nextval, sequences and sequencenames - Mailing list pgsql-general

From missive@frontiernet.net (Lee Harr)
Subject Re: nextval, sequences and sequencenames
Date
Msg-id 9lcl6q$1908$3@node21.cwnet.roc.gblx.net
Whole thread Raw
In response to nextval, sequences and sequencenames  (Wieger Uffink <wieger@usmedia.nl>)
Responses Re: nextval, sequences and sequencenames  (Chris <csmith@squiz.net>)
List pgsql-general
> 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.

pgsql-general by date:

Previous
From: Jason Turner
Date:
Subject: Re: Null Conversion
Next
From: Chris
Date:
Subject: Re: nextval, sequences and sequencenames