Re: Solution proposal for TODO item "Clients: sequences"

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gevik Babakhani <gevik(at)xs4all(dot)nl>
Cc: "Pgsql-Hackers(at)Postgresql(dot) Org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Solution proposal for TODO item "Clients: sequences"
Date: 2004-11-30 02:47:29
Message-ID: 200411300247.iAU2lTf09314@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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(at)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2004-11-30 02:47:42 Re: Opinions on Usenet ...
Previous Message Bruce Momjian 2004-11-30 02:44:45 Re: Auto Vacuum