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
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 |