Re: Changing the continuation-line prompt in psql?

Greg Stark <gsstark(at)mit(dot)edu> writes:
> On Fri, Apr 29, 2011 at 5:45 PM, Christopher Browne <cbbrowne(at)gmail(dot)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