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