Re: sintax error - Mailing list pgsql-sql

From Tom Lane
Subject Re: sintax error
Date
Msg-id 22663.1334154546@sss.pgh.pa.us
Whole thread Raw
In response to Re: sintax error  (kevalshah <keval.shah29@gmail.com>)
List pgsql-sql
kevalshah <keval.shah29@gmail.com> writes:
> At present whenever there is any error in syntax of fired query 
> i get error message in terms of charcter "at char 53 "
> I also would like to have line no: from psql terminal..

Umm ... any reasonably recent version of psql will show syntax errors
like this:

regression=# select 1/ from foo;
ERROR:  syntax error at or near "from"
LINE 1: select 1/ from foo;                 ^

If you're using something so old that it doesn't do that, the answer
is to update.
        regards, tom lane


pgsql-sql by date:

Previous
From: kevalshah
Date:
Subject: Re: sintax error
Next
From: yeison garcia
Date:
Subject: Re: Pregunta acerca de la función COPY de POSTGRES