Thread: BUG #16011: Select * query for sequences does not show all columns in output.
BUG #16011: Select * query for sequences does not show all columns in output.
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 16011 Logged by: Pallavi Pathak Email address: pallavi.pathak@outlook.com PostgreSQL version: 11.5 Operating system: Windows Description: 0 I am upgrading postgres from 9.1 to 11.5 . but select query on sequences is returning different output in 11.5 as compared to 9.1, not all columns are shown in the output. Output in 11.5 SELECT * FROM session_SEQ; 11.5 : last_value | log_cnt | is_called ------------+---------+----------- 1 | 0 | f (1 row) Output in 9.1: SELECT * FROM session_SEQ; sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called ---------------+------------+-------------+--------------+-----------+-----------+-------------+---------+-----------+----------- session_seq | 1 | 1 | 1 | 99999999 | 1 | 1 | 0 | f | f How can we display all the columns in 11.5? is there any workaround?
Re: BUG #16011: Select * query for sequences does not show allcolumns in output.
From
Anthony Sotolongo
Date:
hi, this is not a bug, the catalog change from pg 10 , you can get the rest of columns in pg_sequences catalog view select * from pg_sequences where sequencename = 'session_SEQ' regards On 17-09-19 2:45 p. m., PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 16011 > Logged by: Pallavi Pathak > Email address: pallavi.pathak@outlook.com > PostgreSQL version: 11.5 > Operating system: Windows > Description: > > 0 > > > I am upgrading postgres from 9.1 to 11.5 . > > but select query on sequences is returning different output in 11.5 as > compared to 9.1, not all columns are shown in the output. > > Output in 11.5 > > SELECT * FROM session_SEQ; > > 11.5 : last_value | log_cnt | is_called ------------+---------+----------- 1 > | 0 | f (1 row) > > Output in 9.1: > > SELECT * FROM session_SEQ; > > sequence_name | last_value | start_value | increment_by | max_value | > min_value | cache_value | log_cnt | is_cycled | is_called > ---------------+------------+-------------+--------------+-----------+-----------+-------------+---------+-----------+----------- > session_seq | 1 | 1 | 1 | 99999999 | 1 | 1 | 0 | f | f > > How can we display all the columns in 11.5? is there any workaround? >