| 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: | Whole Thread | Raw Message | 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 |