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

Solution proposal for TODO item "Clients: sequences"

From: "Gevik Babakhani" <gevik(at)xs4all(dot)nl>
To: "Pgsql-Hackers(at)Postgresql(dot) Org" <pgsql-hackers(at)postgresql(dot)org>
Cc: <gevik(at)xs4all(dot)nl>
Subject: Solution proposal for TODO item "Clients: sequences"
Date: 2004-11-29 21:21:04
Message-ID: 200411292121.iATLL38M009856@smtp-vbr5.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
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=#


Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2004-11-29 21:31:32
Subject: Re: USENET vs Mailing Lists Poll ...
Previous:From: Chris GreenDate: 2004-11-29 21:14:18
Subject: Re: USENET vs Mailing Lists Poll ...

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