Skip site navigation (1) Skip section navigation (2)

Re: Changing the continuation-line prompt in psql?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing the continuation-line prompt in psql?
Date: 2011-04-29 18:10:50
Message-ID: BANLkTik6KFK-+5kmeKd2JrrTscmDA2OXQg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2011/4/29 Greg Stark <gsstark(at)mit(dot)edu>:
> 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;
>  ?column? | ?column? | ?column?
> ----------+----------+----------
>        1 |        2 |        3
> (1 row)

+1

Pavel
>
>
> --
> greg
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-04-29 18:11:02
Subject: Re: Changing the continuation-line prompt in psql?
Previous:From: Stephen FrostDate: 2011-04-29 18:10:19
Subject: Re: Changing the continuation-line prompt in psql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group