Re: Changing the continuation-line prompt in psql?

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