Thanks Thomas !!!
Now, it's working fine.
On Wed, Jan 20, 2016 at 5:18 PM, Thomas Kellerer <spam_eater@xxxxxxx> wrote:
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@xxxxxxxxxxxxxxxxxxxxx <mailto:AUTONUMBERSETTING@xxxxxxxxxxxxxxxxxxxxx>
> ^
> ********** Error **********
> ERROR: syntax error at or near "@"
> SQL state: 42601
> Character: 3274
>
Well, AUTONUMBERSETTING@xxxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxxxxx"
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
