Re: ERROR for '@' for function

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR for '@' for function
Date: 2016-01-20 11:48:12
Message-ID: n7ns5s$up9$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)REPOS(dot)BIRCHSTREET(dot)NET <mailto:AUTONUMBERSETTING(at)REPOS(dot)BIRCHSTREET(dot)NET>
> ^
> ********** Error **********
> ERROR: syntax error at or near "@"
> SQL state: 42601
> Character: 3274
>

Well, AUTONUMBERSETTING(at)REPOS(dot)BIRCHSTREET(dot)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(at)REPOS(dot)BIRCHSTREET(dot)NET"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2016-01-20 12:03:47 Re: ERROR for '@' for function
Previous Message Sachin Srivastava 2016-01-20 11:42:35 ERROR for '@' for function