Re: VIP: new format for psql - shell - simple using psql in shell

From: Jan-Benedict Glaw <jbglaw(at)lug-owl(dot)de>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: VIP: new format for psql - shell - simple using psql in shell
Date: 2012-05-26 18:57:41
Message-ID: 20120526185741.GG27648@lug-owl.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On Sat, 2012-05-26 17:39:23 +0200, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> postgres=# select * from foo;
[...]
> postgres=# \pset format shell
> Output format is shell.
> postgres=# select * from foo;
> a b c
> Hello,\ World 10 2012-05-26
> Ahoj,\ Svete 20 2012-06-15
[...]

I like that idea! Up to now, I basically used IFS='|' with
tuples-only, but it's not clean wrt. '\n' within the data.

I didn't check your patch if it gets this "right", but if it does, it
would ease daily work (where I check for '\n' in the data beforehand
and abort...)

MfG, JBG

--
Jan-Benedict Glaw jbglaw(at)lug-owl(dot)de +49-172-7608481
Signature of: Fortschritt bedeutet, einen Schritt so zu machen,
the second : daß man den nächsten auch noch machen kann.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-05-26 19:14:18 Synchronized scans versus relcache reinitialization
Previous Message Greg Sabino Mullane 2012-05-26 17:26:38 Re: Backends stalled in 'startup' state: index corruption