Re: psql shows line number

Marko Tiikkaja <marko@joh.to> writes:
> On 11/26/13 2:24 PM, Pavel Stehule wrote:
>> yes, but we can define new statement like \sq+ (Show Query)

> There's already \p; might not be too difficult to add a \p+ which would 
> also show the line numbers.

I don't actually see the point of this.  If you're working with queries
that are long enough that counting lines is even slightly difficult,
surely you're going to use \e to correct the problem?  So it seems to
me that the existing "\e nnn" facility pretty much does what's needed,
and there's no great need to clutter your regular display with line
numbers.
        regards, tom lane