Querying the last value of all sequences

Поиск
Список
Период
Сортировка
От
Тема Querying the last value of all sequences
Дата
Msg-id 65086.216.238.112.88.1051737623.squirrel@$HOSTNAME
обсуждение исходный текст
Ответы Re: Querying the last value of all sequences  (DeJuan Jackson <djackson@speedfc.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Ron Mayer"
Дата:
Сообщение: Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Buffer Cache question....