Re: Field Separator not working?
От | Mario Splivalo |
---|---|
Тема | Re: Field Separator not working? |
Дата | |
Msg-id | 1129724373.3186.10.camel@ekim обсуждение исходный текст |
Ответ на | Re: Field Separator not working? (Richard Huxton <dev@archonet.com>) |
Список | pgsql-sql |
On Wed, 2005-10-19 at 11:43 +0100, Richard Huxton wrote: > Mario Splivalo wrote: > > pulitzer2=# \t > > Showing only tuples. > > pulitzer2=# \f# > > Field separator is "#". > > pulitzer2=# select * from pg_user; > > mario | 1 | t | t | t | ******** | > > > psql does tell me that I changed the field separator to "#", but it > > still uses "|" as separator. I'm parsing the script from bash, using > > psql, and setting the field separator options on the command line, but I > > get similair results, the field separator is always "|", so I need to > > awk-it with -F, but sometimes I have problems because data in my tables > > often contain "|" charachter. > > You'll want this too: > \pset format unaligned > > man psql or see the manual for full details Hopla. It works perfetcly, thnx. Sometimes we're lazy to trough-read the manuals :) Mario -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."
В списке pgsql-sql по дате отправления: