From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
Date: Sun, 30 May 2010 10:37:12 +0200
Message-ID: <4C0223B8.6050009@2ndQuadrant.it> (raw)
In-Reply-To: <C8273570.AF06%tsakai@gallo.ucsf.edu>
References: <C8273570.AF06%tsakai@gallo.ucsf.edu>
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
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: gabriele.bartolini@2ndQuadrant.it, tsakai@gallo.ucsf.edu
Subject: Re: What is field separator?
In-Reply-To: <4C0223B8.6050009@2ndQuadrant.it>
* 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