For \ds command,
this patch displays the current sequence value(last_value) for each
sequence.
This was suggested during the earlier discussion.
Output of the current patch:
--------------------------------------
mydb=# \ds
List of relations
Schema | Name | Type | Owner | Seq Value
--------+------+----------+----------+-----------
public | a | sequence | Dhanaraj | 5
public | b | sequence | Dhanaraj | 2
public | c | sequence | Dhanaraj | 1
(3 rows)
output without aplying the patch
--------------------------------------------
mydb=# \ds
List of relations
Schema | Name | Type | Owner
--------+------+----------+----------+-----
public | a | sequence | Dhanaraj
public | b | sequence | Dhanaraj
public | c | sequence | Dhanaraj
(3 rows)
Peter Eisentraut wrote:
Dhanaraj M wrote:
This patch was discussed a few months ago.
I could not complete this patch at that time.
I hope that the current version of my patch is acceptable.
What is this patch supposed to be doing?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq