how to access columns if they are named after numbers

Question

My column names in my table are just numbers from 0-20, where each column is corresponding to a number however, when I try

    select 0 from table

I get output of only zeroes in my column, how can I select a column without changing the column names?

https://docs.aws.amazon.com/redshift/latest/dg/r_names.html#r_names-delimited-identifiers — , Jan 21 '21 at 19:23

score 3 · Answer 1 · edited Jan 21 '21 at 19:20

3

select "0" from table

edited Jan 21 '21 at 19:20

answered Jan 21 '21 at 19:15

Matthew Jackson

score 0 · Answer 2 · answered Jan 21 '21 at 19:13

0

Try select [0] from table. Your way is replicating zeros for all entries in the table

answered Jan 21 '21 at 19:13

Johnny Fitz

SQL uses double quotes to escape invalid identifiers. Square brackets are use to reference array elements – Jan 21 '21 at 19:21

2 Answers2