Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 625C0632C05
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 31 May 2010 00:28:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 99824-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 31 May 2010 03:27:53 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.egcrc.net (mail.egcrc.net [63.193.204.10])
	by mail.postgresql.org (Postfix) with ESMTP id 378E1632B59
	for <pgsql-admin@postgresql.org>; Mon, 31 May 2010 00:27:52 -0300 (ADT)
Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org
	([fe80::5c82:4343:5244:a0d5%11]) with mapi;
	Sun, 30 May 2010 20:27:51 -0700
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Sun, 30 May 2010 20:25:26 -0700
Subject: Re: What is field separator?
Thread-Topic: [ADMIN] What is field separator?
Thread-Index: Acr/00+oD/H6TS7ZQuiH+UhXrxRPXAAnZmYR
Message-ID: <C8287A36.AF1E%tsakai@gallo.ucsf.edu>
In-Reply-To: <4C0223B8.6050009@2ndQuadrant.it>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201005/295
X-Sequence-Number: 34768

Thank you, Gabriele.

Now I realize "context sensitive" nature of field separator.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


On 5/30/10 1:37 AM, "Gabriele Bartolini" <gabriele.bartolini@2ndQuadrant.it=
>
wrote:

> Tena Sakai ha scritto:
>> Can somebody please tell me what =B3|=B2 is called in my example above?
>> And is it possible to change it from =B3|=B2 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).
>=20
> In order for it to be effective, you need to type in psql:
>=20
> \pset format unaligned
> \pset fieldsep '\t'
>=20
> This will give you an output with columns that are separated by tab.
>=20
> 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
>=20
> Cheers,
> Gabriele