Lists: | pgsql-hackers |
---|
From: | "Aftab Hussain" <aftab(dot)hussain(at)enterprisedb(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | psql's describe command (for sequences) output improvement |
Date: | 2007-12-04 14:28:39 |
Message-ID: | 51494DB187D98F4C88DBEBF1F5F6D4230D1269@edb06.mail01.enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi all,
I have a patch which tries to improve the '\d some_sequence_name' command output in psql utility. Before sending the patch to pgsql-patches I just want to know your opinion whether the new output of the command is OK or it needs to be modified before sending it to pgsql-patches.
For comparison purpose, here is the output of the '\d some_sequence_name' command:
-- Say we have created a sequence named 'test_seq' already as CREATE SEQUENCE test_seq.
--
-- Output: before applying the patch.
--
testdb=# \d test_seq;
Sequence "public.test_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
--
-- Output: after applying the patch.
--
testdb=# \d test_seq;
Sequence "public.test_seq"
last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f
Thanks in advance for your feedback(s).
--
Aftab.
From: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: psql's describe command (for sequences) output improvement |
Date: | 2007-12-04 14:47:05 |
Message-ID: | a2de01dd0712040647r21acbd3cy35941942b4df27b5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 04/12/2007, Aftab Hussain <aftab(dot)hussain(at)enterprisedb(dot)com> wrote:
>
>
> Hi all,
>
> I have a patch which tries to improve the '\d some_sequence_name' command
> output in psql utility. Before sending the patch to pgsql-patches I just
> want to know your opinion whether the new output of the command is OK or it
> needs to be modified before sending it to pgsql-patches.
>
> For comparison purpose, here is the output of the '\d some_sequence_name'
> command:
>
> -- Say we have created a sequence named 'test_seq' already as CREATE
> SEQUENCE test_seq.
>
> --
> -- Output: before applying the patch.
> --
> testdb=# \d test_seq;
> Sequence "public.test_seq"
> Column | Type
> ---------------+---------
> sequence_name | name
> last_value | bigint
> increment_by | bigint
> max_value | bigint
> min_value | bigint
> cache_value | bigint
> log_cnt | bigint
> is_cycled | boolean
> is_called | boolean
>
> --
> -- Output: after applying the patch.
> --
> testdb=# \d test_seq;
> Sequence "public.test_seq"
> last_value | increment_by | max_value | min_value | cache_value
> | log_cnt | is_cycled | is_called
>
> ------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
> 1 | 1 | 9223372036854775807 | 1 | 1
> | 1 | f | f
>
>
>
> Thanks in advance for your feedback(s).
>
> --
> Aftab.
>
Why?
is that not what
select * from test_seq;
does already.
\d command return meta data not data.
Peter Childs
From: | "Aftab Hussain" <aftab(dot)se(at)gmail(dot)com> |
---|---|
To: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: psql's describe command (for sequences) output improvement |
Date: | 2007-12-05 08:31:22 |
Message-ID: | 1fe1c5a10712050031q660ffd72u951e8fced66042ad@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Dec 4, 2007 7:47 PM, Peter Childs <peterachilds(at)gmail(dot)com> wrote:
>
>
> On 04/12/2007, Aftab Hussain <aftab(dot)hussain(at)enterprisedb(dot)com> wrote:
> >
> >
> > Hi all,
> >
> > I have a patch which tries to improve the '\d some_sequence_name'
> > command output in psql utility. Before sending the patch to pgsql-patches I
> > just want to know your opinion whether the new output of the command is OK
> > or it needs to be modified before sending it to pgsql-patches.
> >
> > For comparison purpose, here is the output of the '\d
> > some_sequence_name' command:
> >
> > -- Say we have created a sequence named 'test_seq' already as CREATE
> > SEQUENCE test_seq.
> >
> > --
> > -- Output: before applying the patch.
> > --
> > testdb=# \d test_seq;
> > Sequence "public.test_seq"
> > Column | Type
> > ---------------+---------
> > sequence_name | name
> > last_value | bigint
> > increment_by | bigint
> > max_value | bigint
> > min_value | bigint
> > cache_value | bigint
> > log_cnt | bigint
> > is_cycled | boolean
> > is_called | boolean
> >
> > --
> > -- Output: after applying the patch.
> > --
> > testdb=# \d test_seq;
> > Sequence "public.test_seq"
> > last_value | increment_by | max_value | min_value |
> > cache_value | log_cnt | is_cycled | is_called
> >
> > ------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
> > 1 | 1 | 9223372036854775807 | 1 |
> > 1 | 1 | f | f
> >
> >
> >
> > Thanks in advance for your feedback(s).
> >
> > --
> > Aftab.
> >
> Why?
>
> is that not what
>
> select * from test_seq;
>
> does already.
>
> \d command return meta data not data.
>
> Peter Childs
>
In general, \d command is working perfectly for database objects.
For sequences, I think the current \d some_sequence command's output is
displaying information which does not help the end user very much. Also
isn't the newly display information (same as information provided by 'select
* from test_seq;' statement) is/can-be-considered the metadata information
about the sequences queried about (since for the returning sequences data we
have nextval('...'), currval('...') functions)?
Please correct me if I am wrong or have missed something.
Aftab Hussain.
EnterpriseDB. www.enterprisedb.com
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Aftab Hussain <aftab(dot)se(at)gmail(dot)com> |
Cc: | Peter Childs <peterachilds(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: psql's describe command (for sequences) output improvement |
Date: | 2007-12-16 06:48:22 |
Message-ID: | 200712160648.lBG6mMW27402@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Aftab Hussain wrote:
> In general, \d command is working perfectly for database objects.
>
> For sequences, I think the current \d some_sequence command's output is
> displaying information which does not help the end user very much. Also
> isn't the newly display information (same as information provided by 'select
> * from test_seq;' statement) is/can-be-considered the metadata information
> about the sequences queried about (since for the returning sequences data we
> have nextval('...'), currval('...') functions)?
Yes, you are kind of right that \d on sequences provides unhelpful
output, but having it display the sequence values seems odd. TODO has:
o Have psql show current values for a sequence
Maybe \d+ sequence_name should add a column that shows the current
values:
test=> \d+ x
Sequence "public.x"
Column | Type | Value | Description
---------------+---------+----------------------
sequence_name | name | x
last_value | bigint | 1
increment_by | bigint |
max_value | bigint |
min_value | bigint |
cache_value | bigint |
log_cnt | bigint |
is_cycled | boolean |
is_called | boolean |
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +