Re: Field Separator not working?

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