From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
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-27 12:15:20 |
Message-ID: | 20120527121520.GA2199@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, May 26, 2012 at 05:39:23PM +0200, Pavel Stehule wrote:
> I proposed new psql's format "shell". This format is optimized for
> processing returned result in shell:
While I generally like the idea, please note that safe reading output
from queries is possible, with COPY, and proper IFS, like:
=$ psql -c "select * from t"
a | b | c
----+-----+-----------
a1 | b 2 | c|3
a +| b +| c:| 6
4 | 5 +|
| |
(2 rows)
=$ psql -qAtX -c "copy (select * from t) to stdout" | while IFS=$'\t' read -r a b c; do echo -e "a=[$a] b=[$b] c=[$c]"; done
a=[a1] b=[b 2] c=[c|3]
a=[a
4] b=[b
5
] c=[c:| 6]
that being said - I would love to get more functional psql.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2012-05-27 12:48:54 | Re: pg_upgrade libraries check |
Previous Message | Bruce Momjian | 2012-05-27 10:40:59 | Re: pg_upgrade libraries check |