Display View Column Names in vsql

[heather]

Hi,

How can I display the the columns in a view in vsql? The \d and \dv commands don't show the columns I have to keep selecting just one row (limit 1) to check the column names.

Thanks

[id10t]

Hi!

Code: Select all

daniel=> select export_objects('','view_name');

Code: Select all

daniel=> select ordinal_position, column_name, data_type from view_columns where table_name = 'view_name' order by ordinal_position;

[heather]

Ok, thanks, sKwa. I was hoping there was a describe option like a describe table...

[id10t]

Hi!

If you are using vsql you always can set an alias:

Code: Select all

daniel=> \set show_view 'select ordinal_position, column_name, data_type from view_columns where table_name = '
daniel=> :show_view 'my_view';
 ordinal_position | column_name |  data_type  
------------------+-------------+-------------
                1 | id          | int
                2 | name        | varchar(80)
                3 | salary      | int
                4 | dept        | int
(4 rows)

write it in '.vsqlrc' file to set it permanent

[heather]

Thanks, sKwa! That's cool! I will use this solution

[JimKnicely]

#skwa: That is a really cool solution!