Hi all, These patch implements the TODO item: Have psql show current values for a sequence. Comments are welcome.
* Credits The original patch were developed by Euler Taveira de Oliveira <[EMAIL PROTECTED]> but how he is a little busy, he sends it to me and I made some changes to satisfy the TODO item above. * Discussions http://archives.postgresql.org/pgsql-hackers/2007-12/msg00102.php http://archives.postgresql.org/pgsql-hackers/2007-12/msg00605.php * Outputs # \d foo_bar_seq Sequence "public.foo_bar_seq" +---------------+---------+---------------------+ | Column | Type | Value | +---------------+---------+---------------------+ | sequence_name | name | foo_bar_seq | | last_value | bigint | 11 | | start_value | bigint | 1 | | increment_by | bigint | 1 | | max_value | bigint | 9223372036854775807 | | min_value | bigint | 1 | | cache_value | bigint | 1 | | log_cnt | bigint | 31 | | is_cycled | boolean | f | | is_called | boolean | t | +---------------+---------+---------------------+ # \d+ foo_bar_seq Sequence "public.foo_bar_seq" +---------------+---------+---------------------+-------------+ | Column | Type | Value | Description | +---------------+---------+---------------------+-------------+ | sequence_name | name | foo_bar_seq | | | last_value | bigint | 11 | | | start_value | bigint | 1 | | | increment_by | bigint | 1 | | | max_value | bigint | 9223372036854775807 | | | min_value | bigint | 1 | | | cache_value | bigint | 1 | | | log_cnt | bigint | 31 | | | is_cycled | boolean | f | | | is_called | boolean | t | | +---------------+---------+---------------------+-------------+ -- []s Dickson S. Guedes -------------------------------------- Projeto Colmeia - Curitiba - PR +55 (41) 3254-7130 ramal: 27 http://makeall.wordpress.com/ http://pgcon.postgresql.org.br/ http://planeta.postgresql.org.br/
psql-show-current-values-for-sequence-v2.diff.gz
Description: GNU Zip compressed data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
