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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
Sent: Sunday, June 05, 2005 3:17 AM
To: Gevik Babakhani
Cc: [EMAIL PROTECTED] 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
----------------------------------------------------------------
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
