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
-- Richard Huxton Archonet Ltd