From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
Date: Sun, 30 May 2010 20:25:26 -0700
Message-ID: <C8287A36.AF1E%tsakai@gallo.ucsf.edu> (raw)
In-Reply-To: <4C0223B8.6050009@2ndQuadrant.it>
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 ³|² 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tsakai@gallo.ucsf.edu, gabriele.bartolini@2ndQuadrant.it
Subject: Re: What is field separator?
In-Reply-To: <C8287A36.AF1E%tsakai@gallo.ucsf.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox