Re: ERROR for '@' for function

Thanks Thomas !!!

Now, it's working fine.

On Wed, Jan 20, 2016 at 5:18 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> 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(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"
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>