On Tue, Sep 06, 2005 at 23:43:44 -0300,
Joÿffffffffffe3o Carvalho <[EMAIL PROTECTED]> wrote:
> Is it possible to get from a sequence:
>
> The sequence owner
> The min value
> The max value
> The increment value
> The last used number
Yes. Associated with each sequence is a one row table with the name of the
sequence. Note that numbers can be allocated and not used, so the last_value
may not be exactly what you want.
To get the owner you can combine pg_class with pg_user to get the table
owner. I didn't see this information in the information schema.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
