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  ("Aftab Hussain" <aftab.se@gmail.com>)
Список pgsql-hackers


On 04/12/2007, Aftab Hussain <aftab.hussain@enterprisedb.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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Aftab Hussain"
Дата:
Сообщение: psql's describe command (for sequences) output improvement
Следующее
От: Simon Riggs
Дата:
Сообщение: TOASTed size