Re: nextval, sequences and sequencenames

Hi,

> > 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.

Not hard at all.

csmith=# create table test (testid serial, name text);
NOTICE:  CREATE TABLE will create implicit sequence 'test_testid_seq' for
SERIAL column 'test.testid'
NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'test_testid_key'
for table 'test'
CREATE

Sequence name becomes <tablename>_<columnname>_seq

so if we use the serial datatype to create a column called "xyz" in the
table "abc" the sequence name is :

abc_xyz_seq

Make sense?


-----------------
      Chris Smith
http://www.squiz.net/