psql shows line number - Mailing list pgsql-hackers

From Sawada Masahiko
Subject psql shows line number
Date
Msg-id CAD21AoBpuFLf4yazeckDcyDbxwb0DGMNnezGEtjMMnDqvnEoSA@mail.gmail.com
Whole thread Raw
Responses Re: psql shows line number  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: psql shows line number  (Marko Tiikkaja <marko@joh.to>)
List 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



pgsql-hackers by date:

Previous
From: Rajeev rastogi
Date:
Subject: Re: TODO: Split out pg_resetxlog output into pre- and post-sections
Next
From: Pavel Stehule
Date:
Subject: Re: ToDo: fast update of arrays with fixed length fields for PL/pgSQL