Choosing the name of a column when creating a view in Redshift

user_11427439 0
Viewed 138

I'm trying to create a view that contains a column with a list of codes. This is the SQL code that I currently have:

DROP VIEW IF EXISTS myview;
CREATE OR REPLACE VIEW myview as
SELECT 'code1'
UNION
SELECT 'code2'
UNION
SELECT 'code3'

This creates a view with this column:

?column?
code1
code2
code3

As you can see the column name is "?column?" and I would like to change it to a name of my choice. I've tried looking at the Redshift documentation where it says that you can specify a column name, but I'm not sure what's the correct syntax since they don't give any examples.

amazon-redshift view sql database
1 Answers

just add an alias with the name of column

CREATE OR REPLACE VIEW logs.myview as
SELECT 'code1' as my_column
UNION
SELECT 'code2'
UNION
SELECT 'code3';
user_7983350
Related