On 04/12/2007, Aftab Hussain <[EMAIL PROTECTED]> 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
