Re: sintax error

kevalshah <keval(dot)shah29(at)gmail(dot)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