Select column name containing forward slash in PostgreSQL

Question

I am new to PostgreSQL and trying the below two scenarios:

Select a column name which already has a forward slash(/) in database (Road/Highway)
Using case on same column along with index

Select Road/Highway, 
case 
 when index(upcase(Road/Highway), 'xturn') > 0 then 2
 else 0
end as preferred_road
from abc_data;

But I am getting syntax error near index and for slash it is only taking Road.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS — , Dec 16 '20 at 17:17

Gregor Thomas · Answer 1 · 2020-12-16T16:34:47.980

2

Generally / means "division", so your column name is non-standard, much like working with keyword column names, column names with special characters must be quoted with double quotes. Use "Road/Highway" when referring to the column.

edited Dec 16 '20 at 16:34

answered Dec 16 '20 at 16:31

Gregor Thomas

136,190
20
167
294

Thanks for the correcction! – Gregor Thomas Dec 16 '20 at 16:36
Thanks @Gregor , any thoughts on the ```case``` part? – Deb Dec 16 '20 at 16:40
Use double quotes **everywhere** you refer to the column. Without quotes, it will look for a column name "Road" and a column named "Highway" and try to divide them. – Gregor Thomas Dec 16 '20 at 16:43

Select column name containing forward slash in PostgreSQL

1 Answers1