Re: psql shows line number

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql shows line number
Date: 2013-11-26 12:23:14
Message-ID: 529492B2.3080500@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/26/13 1:05 PM, Sawada Masahiko wrote:
> When I execute query which contains error, the server returns error
> with line number.
>
> ERROR: relation "hoge" does not exist
> LINE 35: hoge;
>
> But when query is long, I was not sure the location where I wrote wrong SQL.
> Does the psql have option which shows line number?
> If no, I'm thinking to implement this feature. Thought?
> I think it is useful if the psql shows line number like follows

If the query is long, you'll likely want to \e to edit it anyway, no?
I'm sure any text editor worth $EDITOR will know how to jump to a
specific line.

Regards,
Marko Tiikkaja

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-11-26 12:32:44 Incomplete freezing when truncating a relation during vacuum
Previous Message Pavel Stehule 2013-11-26 12:17:11 Re: psql shows line number