How to handle Vertica Columns having Dot(.)

Hi All,

We have a requirement where we are building Vertica Flex tables from JSON files. As its automatically getting created we have few column names like:

temp.source

temp.email

temp.name

temp.id

Now I am not able to select those columns directly using the column names, Ex:

Select temp.source,temp.email,temp.name, temp.id from temp_table;

YThe above statement gives me error saying, column temp does not exit. I know its because of Dot(.) present in between the column name. Now if I put the column names with in quote(" ") like below, I am not getting that error

Ex:

Select "temp.source","temp.email","temp.name", "temp.id" from temp_table;

Is there any other way of handling this without adding quotes or updating the column names.

Any help would be much appreciated.

Thanks,

-Amit