Thread: Querying the last value of all sequences

I know that I can get a list of all sequences with

SELECT
  c.relname AS sequencename
FROM pg_class c WHERE (c.relkind = 'S');

which produces, for example,

country_country_pk_seq
province_province_pk_seq
city_city_pk_seq
postal_code_postal_code_pk_seq


And I know I can get the last value from a particular sequence with

SELECT
 sequence_name,
 last_value
FROM city_city_pk_seq

which produces, for example

city_city_pk_seq    14702


But how can I get a list of sequence names and the respective last value
for ALL sequences?









~Berend Tober

You could make creative use of psql (if you just want the results for
yourself);

\a
\t

SELECT
  'SELECT
 sequence_name,
 last_value
FROM' || c.relname
FROM pg_class c WHERE (c.relkind = 'S') \g | psql <database>
\t
\a



btober@seaworthysys.com wrote:

>I know that I can get a list of all sequences with
>
>SELECT
>  c.relname AS sequencename
>FROM pg_class c WHERE (c.relkind = 'S');
>
>which produces, for example,
>
>country_country_pk_seq
>province_province_pk_seq
>city_city_pk_seq
>postal_code_postal_code_pk_seq
>
>
>And I know I can get the last value from a particular sequence with
>
>SELECT
> sequence_name,
> last_value
>FROM city_city_pk_seq
>
>which produces, for example
>
>city_city_pk_seq    14702
>
>
>But how can I get a list of sequence names and the respective last value
>for ALL sequences?
>
>
>
>
>
>
>
>
>
>~Berend Tober
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
>
>