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.

postgresql.org/docs/current/…

user330315
– user330315

2020-12-16 17:17:42 +00:00
Commented Dec 16, 2020 at 17:17 — user330315
– user330315, Commented Dec 16, 2020 at 17:17

Gregor Thomas · Accepted Answer · 2020-12-16 16:34:47Z

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, 2020 at 16:34

answered Dec 16, 2020 at 16:31

Gregor Thomas

147k22 gold badges185 silver badges320 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gregor Thomas Over a year ago

Thanks for the correcction!

Deb Over a year ago

Thanks @Gregor , any thoughts on the case part?

Gregor Thomas Over a year ago

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.

Collectives™ on Stack Overflow

Select column name containing forward slash in PostgreSQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related