Re: psql's describe command (for sequences) output improvement
От | Peter Childs |
---|---|
Тема | Re: psql's describe command (for sequences) output improvement |
Дата | |
Msg-id | a2de01dd0712040647r21acbd3cy35941942b4df27b5@mail.gmail.com обсуждение исходный текст |
Ответ на | psql's describe command (for sequences) output improvement ("Aftab Hussain" <aftab.hussain@enterprisedb.com>) |
Ответы |
Re: psql's describe command (for sequences) output improvement
|
Список | 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.
is that not what
select * from test_seq;
does already.
\d command return meta data not data.
Peter Childs
В списке pgsql-hackers по дате отправления: