2012/5/26 Bruce Momjian <br...@momjian.us>: > 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? >
"read" can read multicolumn files, where space is separator and real space is escaped. It is first sample. Second example is related to Bash's feature - associative array support - data has format that is same like assoc array Pavel > -- > 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
