That would be something good for 8.1 so I will keep your email.
This has been saved for the 8.1 release:
http:/momjian.postgresql.org/cgi-bin/pgpatches2
---------------------------------------------------------------------------
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
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
