From: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR for '@' for function |
Date: | 2016-01-20 12:03:47 |
Message-ID: | CAFzqEhKNq+N3K8X+6TRWpwuA8T9-qwOcyYnUcuYwE53+MO_7NA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sachin Srivastava | 2016-01-20 12:15:46 | Syntax error for Function |
Previous Message | Thomas Kellerer | 2016-01-20 11:48:12 | Re: ERROR for '@' for function |