I am thinking we just add another column to the \d display for sequences showing the current value.
--------------------------------------------------------------------------- Euler Taveira de Oliveira wrote: > Bruce Momjian wrote: > > > What fields do we want to show? Maybe the TODO item is not needed. Is > > this all we want to show? > > > IRC what we want is something like this. > > regression=# \d abc > Sequence "public.abc" > Column | Type > --------------+--------- > sequence_name | abc > last_value | 1 > increment_by | 1 > max_value | 9223372036854775807 > min_value | 1 > cache_value | 1 > log_cnt | 1 > is_cycled | f > is_called | f > > > Because "\d abc" doesn't show us any important information. > > regression=# \d abc > Sequence "public.abc" > Column | Type > ---------------+--------- > sequence_name | name > last_value | bigint > increment_by | bigint > max_value | bigint > min_value | bigint > cache_value | bigint > log_cnt | bigint > is_cycled | boolean > is_called | boolean > > > Last year, I made a patch for this but it was so ugly that I didn't send > to -patches. Maybe Bruce's solution (\x & select * from seq) could be > hardcoded in describe.c. > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
