Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id C8A5AF7659 for ; Wed, 11 Apr 2012 11:29:23 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SHyXx-0007pU-JV for pgsql-sql@postgresql.org; Wed, 11 Apr 2012 14:29:23 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q3BET6F2022664; Wed, 11 Apr 2012 10:29:06 -0400 (EDT) To: kevalshah cc: pgsql-sql@postgresql.org Subject: Re: sintax error In-reply-to: <1334145427988-5632590.post@n5.nabble.com> References: <4B7E4331.1050308@gmail.com> <4B7E6E47.5020503@archonet.com> <1334145427988-5632590.post@n5.nabble.com> Comments: In-reply-to kevalshah message dated "Wed, 11 Apr 2012 04:57:07 -0700" Date: Wed, 11 Apr 2012 10:29:06 -0400 Message-ID: <22663.1334154546@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/23 X-Sequence-Number: 36500 kevalshah 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