On Sat, May 26, 2012 at 05:39:23PM +0200, Pavel Stehule wrote: > Hello > > I proposed new psql's format "shell". This format is optimized for > processing returned result in shell: > > > postgres=# select * from foo; > a | b | c > --------------+----+------------ > Hello, World | 10 | 2012-05-26 > Ahoj, Svete | 20 | 2012-06-15 > (2 rows) > > 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 > > postgres=# \x > Expanded display is on. > postgres=# select * from foo; > ( c l ) > ( [a]=Hello,\ World [b]=10 [c]=2012-05-26 ) > ( [a]=Ahoj,\ Svete [b]=20 [c]=2012-06-15 ) ... > ) | while read dbname owner encoding collate ctype priv;
I am unclear exactly how this relates to shells. Do shells read this via read? I am unclear that would actually work. What do the brackets mean? Does read process \space as a non-space? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
