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