Escaping Spaces in Column names within SQL query

Developer Talk API
1

I’ve got these columns that have spaces in them, this is some legacy stuff I moved over from Airtable and I have for example a Column “Name Bank Statement” and in Airtable I could use the columns with spaces without any issues like this all(filter: "{Name Bank Statement}=\"#{name}\"")
Is there a way to use these Column names in Setable SQL?
I have tried without success:

  • select * from Companies where "Name Bank Statement" =
  • select * from Companies where 'Name Bank Statement' =
  • select * from Companies where 'Name\ Bank\ Statement' =
  • select * from Companies where "Name\ Bank\ Statement" =

all without success. No idea what other options I would have to escape the spaces.

2

Please use apostrophe.

3

aaaa you mean a backtick… didn’t think of that.

select * from Companies where `Name Bank Statement`
4

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.