On Wed, Aug 15, 2001 at 10:49:38AM +0200, Wieger Uffink wrote:
> Hi,
>
> First of all thanks for the reactions, but I think I have probably not
> made my problem clear enough.
>
> I know the sequence name will be some combination, usually as
> 'tablename_columnname_seq',
> when implicitly create
Hi,
First of all thanks for the reactions, but I think I have probably not
made my problem clear enough.
I know the sequence name will be some combination, usually as
'tablename_columnname_seq',
when implicitly created during table creation.
But when I create my table 'maincompetencies' with ser
On Wed, Aug 15, 2001 at 12:14:02PM +1000, Chris wrote:
> >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
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 knowi
> 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
>
