Re: ERROR for '@' for function

Sachin Srivastava schrieb am 20.01.2016 um 12:42:
> How to handle this below situation, I am getting error for function, my  Postgres version is 9.4
>  is
>
> ERROR:  syntax error at or near "@"
> LINE 67:   AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET <mailto:AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET>
>                             ^
> ********** Error **********
> ERROR: syntax error at or near "@"
> SQL state: 42601
> Character: 3274
>

Well, AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET is an invalid identifier.
A "@" is not allowed as part of a table name.

You need to enclose that in double quotes:

SELECT ...
FROM "AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET"