Message-ID: <4C0223B8.6050009@2ndQuadrant.it>
Date: Sun, 30 May 2010 10:37:12 +0200
From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228)
MIME-Version: 1.0
To: Tena Sakai <tsakai@gallo.ucsf.edu>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
References: <C8273570.AF06%tsakai@gallo.ucsf.edu>
In-Reply-To: <C8273570.AF06%tsakai@gallo.ucsf.edu>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Tena Sakai ha scritto:
> Can somebody please tell me what “|” is called in my example above?
> And is it possible to change it from “|” to something else for
> display purpose?
The field separatore in psql is used only when the format is "unaligned" 
(which does not happen to be default).

In order for it to be effective, you need to type in psql:

\pset format unaligned
\pset fieldsep '\t'

This will give you an output with columns that are separated by tab.

However, I suggest that you look at the documentation for more options 
and ways to achive the same results: 
http://www.postgresql.org/docs/current/static/app-psql.html

Cheers,
Gabriele

-- 
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it