Re: psql shows line number

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: psql shows line number
Дата
Msg-id 529492B2.3080500@joh.to
обсуждение исходный текст
Ответ на psql shows line number  (Sawada Masahiko <sawada.mshk@gmail.com>)
Ответы Re: psql shows line number  (Sawada Masahiko <sawada.mshk@gmail.com>)
Список 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
knowhow to jump to a 
 
specific line.



Regards,
Marko Tiikkaja



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: psql shows line number
Следующее
От: Andres Freund
Дата:
Сообщение: Incomplete freezing when truncating a relation during vacuum