| From: | Gordan Bobic <gordan(at)bobich(dot)net> |
|---|---|
| To: | Wieger Uffink <wieger(at)usmedia(dot)nl> |
| Cc: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: nextval, sequences and sequencenames |
| Date: | 2001-08-15 08:14:02 |
| Message-ID: | Pine.LNX.4.33.0108150913120.13628-100000@sentinel.bobich.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
On Tue, 14 Aug 2001, Wieger Uffink wrote:
> 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.
>
Try "tablename_fieldname_seq". That is the default sequence name for a
"serial" field.
Cheers.
Gordan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wieger Uffink | 2001-08-15 08:49:38 | Re: Re: nextval, sequences and sequencenames |
| Previous Message | Martijn van Oosterhout | 2001-08-15 08:04:43 | Re: Re: nextval, sequences and sequencenames |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wieger Uffink | 2001-08-15 08:49:38 | Re: Re: nextval, sequences and sequencenames |
| Previous Message | Martijn van Oosterhout | 2001-08-15 08:04:43 | Re: Re: nextval, sequences and sequencenames |