Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group