Thread: Re: [PATCHES] Patch - Have psql show current values

Re: [PATCHES] Patch - Have psql show current values

From
Peter Eisentraut
Date:
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?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


Re: [PATCHES] Patch - Have psql show current values

From
Dhanaraj M
Date:
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 relationsSchema | Name |   Type   |  Owner   | Seq Value
--------+------+----------+----------+-----------public | a    | sequence | Dhanaraj |         5public | b    |
sequence| Dhanaraj |         2public | c    | sequence | Dhanaraj |         1
 
(3 rows)

output without aplying the patch
--------------------------------------------
mydb=# \ds               List of relationsSchema | Name |   Type   |  Owner  
--------+------+----------+----------+-----public | a    | sequence | Dhanarajpublic | b    | sequence | Dhanarajpublic
|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?
>
>  
>