Re: Select START and MAXVALUE from Sequence

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Select START and MAXVALUE from Sequence
Date: 2009-01-31 09:50:41
Message-ID: gm16th$6a2$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2009-01-27, Lukas <lukas(at)fmf(dot)vtu(dot)lt> wrote:
> Hello,
>
>
> Is here any way to get START and MAXVALUE from sequence in select query.
> I mean something like this:
> Select startval('MySeq'); --This can not work of course.

SELECT * FROM name_of_sequence;

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2009-01-31 09:53:23 Re: Select START and MAXVALUE from Sequence
Previous Message Rodrigo E. De León Plicet 2009-01-31 00:24:34 Re: REALLY stupid question