Sorry for the delay on this. What I did was to mark the simple TODO items as done and add an additional TODO item to list all sequence settings:
D o Have psql show current values for a sequence o Have psql \ds show all sequences and their settings * http://archives.postgresql.org/pgsql-hackers/2008-07/msg00916.php --------------------------------------------------------------------------- Tom Lane wrote: > Bruce Momjian <br...@momjian.us> writes: > > Wow. I adjusted the patch slightly and applied it; the updated version > > is attached. We have been waiting for this to be done for quite some > > time. Thanks. > > Hmm ... I don't think that this patch actually addresses the TODO item. > The TODO item seems to have originated here > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1220;r2=1.1221;f=h > in response to this question on pgsql-novice: > > > How can I list all the sequences in the database, with their > > attributes (such as last_value)? (I'm having a hard time guessing > > 'seq-name'; the 'A_id_seq' formula did not work.) > http://archives.postgresql.org/pgsql-novice/2004-02/msg00148.php > > This applied-with-little-discussion patch only shows the sequence > values if you do a \d on a specific sequence, or \d on a wildcard > that happens to include some sequences (and probably a lot of other > stuff too, causing the resulting display to be far too long to be > useful). > > My interpretation of the TODO item has always been that we should > improve \ds to include all the useful information in a format that > requires only one line per sequence. The reason it has remained > undone for four years is that that's hard given the existing catalog > representation of sequences and the constraints of describe.c's > implementation. (I recall at least one failed patch that tried to > do this, though I can't find it in the archives right now.) > > I find the present patch to be pretty useless: it's not a material > advance over doing "select * from sequence-name". I think it should > be reverted and the TODO item reinstated --- perhaps with more detail > about what the item really is requesting. > > regards, tom lane -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers