From: Greg Smith <greg@2ndquadrant.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
Date: Wed, 02 Jun 2010 02:02:20 -0400
Message-ID: <4C05F3EC.1020107@2ndquadrant.com> (raw)
In-Reply-To: <C829E86F.AF42%tsakai@gallo.ucsf.edu>
References: <C829E86F.AF42%tsakai@gallo.ucsf.edu>
Tena Sakai wrote:
> I got it to work by emulating what you wrote.
> But I think you meant -A, not -At below.
>
>>> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
>>> -F $'\t'
>>>
You had -t in your original to turn off the display of column names and
the counts at the end, and -A is the shortcut for what you had as "-P
'format=unaligned'". I throw "-At" into almost every use of psql from a
bash script I do, that's the usual combination that gets the basic
format to be right; then tweak things like the field separator afterwards.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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: greg@2ndquadrant.com, tsakai@gallo.ucsf.edu, gabriele.bartolini@2ndQuadrant.it
Subject: Re: What is field separator?
In-Reply-To: <4C05F3EC.1020107@2ndquadrant.com>
* 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