Re: Changing the continuation-line prompt in psql? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Changing the continuation-line prompt in psql?
Date
Msg-id 8365.1304100662@sss.pgh.pa.us
Whole thread Raw
In response to Re: Changing the continuation-line prompt in psql?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> On Fri, Apr 29, 2011 at 5:45 PM, Christopher Browne <cbbrowne@gmail.com> wrote:
>> The "bike shedding" that I'd rather have would involve enclosing
>> prompts with /* comments */ so that cut'n'paste could be expected to
>> generate output that could run, without further editing, in another
>> psql session. �Mind you, whenever I have configured such, I have been
>> unhappy at how wide that makes the prompt and at the loss of screen
>> space.

> I would second this precise interest. It really annoys me more often
> than anything else that when I try to copy/paste an sql query I need
> to copy each line one by one. It would be different from MySql but I
> think it would be even clearer to the user:

> postgres=> select 1,
> /*line 2:*/        2,
> /*line 3:*/        3;

This looks promising until you stop to think about either string
literals or /* comment blocks being continued across lines ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Changing the continuation-line prompt in psql?
Next
From: Pavel Stehule
Date:
Subject: Re: Changing the continuation-line prompt in psql?