I would suggest adding it to \ds or create a \ds+ so that it is in
common with the rest of the commands.
-Jonah
Gevik babakhani wrote:
>So what would be your suggestion in order to add this functionality?
>
>
>-----Original Message-----
>From: pgsql-hackers-owner@postgresql.org
>[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Bruce Momjian
>Sent: Sunday, June 05, 2005 3:17 AM
>To: Gevik Babakhani
>Cc: Pgsql-Hackers@Postgresql. Org
>Subject: Re: [HACKERS] Solution proposal for TODO item "Clients: sequences"
>
>
>It would be nice to add the current sequence value to \ds, but the
>existing psql query would have to be overhauled to do that. Right now
>the same query does all the work for most \d commands.
>
>---------------------------------------------------------------------------
>
>Gevik Babakhani wrote:
>
>
>>Dear People,
>>
>>Hereby a proposal for the TODO item "Clients: Have psql show current
>>
>>
>values
>
>
>>for a sequences".
>>I have added a new slash command to psql client "\sq" for showing the last
>>values of the
>>existing sequences in the public schema. The code is only tested on rh9.
>>
>>The new files are sequence_info.c and sequence_info.h I would like
>>to hear your comments. (Be gentle this is my first)
>>
>>The sources can be downloaded from http://www.truesoftware.net/psql/
>>
>>Regards,
>>Gevik
>>
>>
>>----------------------------------------------------------------
>>SCREEN OUTPUT
>>----------------------------------------------------------------
>>[gevik@voyager psql]$ ./psql
>>Welcome to psql 8.0.0beta5, the PostgreSQL interactive terminal.
>>
>>Type: \copyright for distribution terms
>> \h for help with SQL commands
>> \? for help with psql commands
>> \g or terminate with semicolon to execute query
>> \q to quit
>>
>>gevik=# \sq
>>Current sequence values
>> Sequence | Last value
>>-----------+------------
>> mytableid | 5
>> seq1 | 1
>>(2 rows)
>>
>>gevik=#
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>>
>
>
>