Message-ID: <4356233E.4040700@archonet.com>
Date: Wed, 19 Oct 2005 11:43:10 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
MIME-Version: 1.0
To: mario.splivalo@mobart.hr
Cc: PostgresSQL list <pgsql-sql@postgresql.org>
Subject: Re: Field Separator not working?
References: <1129717152.3186.5.camel@ekim>
In-Reply-To: <1129717152.3186.5.camel@ekim>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

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