Re: nextval, sequences and sequencenames

Поиск
Список
Период
Сортировка
От missive@frontiernet.net (Lee Harr)
Тема Re: nextval, sequences and sequencenames
Дата
Msg-id 9lcl6q$1908$3@node21.cwnet.roc.gblx.net
обсуждение исходный текст
Ответ на nextval, sequences and sequencenames  (Wieger Uffink <wieger@usmedia.nl>)
Ответы Re: nextval, sequences and sequencenames  (Chris <csmith@squiz.net>)
Список 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 по дате отправления:

Предыдущее
От: Jason Turner
Дата:
Сообщение: Re: Null Conversion
Следующее
От: Chris
Дата:
Сообщение: Re: nextval, sequences and sequencenames