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.
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 |