psql shows line number

From: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: psql shows line number
Date: 2013-11-26 12:05:24
Message-ID: CAD21AoBpuFLf4yazeckDcyDbxwb0DGMNnezGEtjMMnDqvnEoSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

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

[1]postgres=# SELECT
[2]postgres=# hoge.col1
[3]postgres=# FROM
[4]postgres=# hoge;

ERROR: column "col1" does not exist
LINE 2: col1

And If there is discussion at past about this, please let me know.

Regards,

-------
Sawada Masahiko

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-11-26 12:08:28 Re: ToDo: fast update of arrays with fixed length fields for PL/pgSQL
Previous Message Rajeev rastogi 2013-11-26 12:03:23 Re: TODO: Split out pg_resetxlog output into pre- and post-sections