From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Greg Smith <greg@2ndquadrant.com>
CC: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Tue, 1 Jun 2010 23:05:11 -0700
Subject: Re: What is field separator?
Thread-Topic: [ADMIN] What is field separator?
Thread-Index: AcsCGS1rhiRdBalcQRyNvyuHhdUQ0QAAGHG5
Message-ID: <C82B42A7.AF6F%tsakai@gallo.ucsf.edu>
In-Reply-To: <4C05F3EC.1020107@2ndquadrant.com>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Greg,

My apologies.  I hadn't realized that -At was a combination
of -A and -t.  Rather, I kept thinking that t as argument
to -A.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


On 6/1/10 11:02 PM, "Greg Smith" <greg@2ndquadrant.com> wrote:

> Tena Sakai wrote:
>> I got it to work by emulating what you wrote.
>> But I think you meant -A, not -At below.
>>  =20
>>>> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
>>>> -F $'\t'
>>>>      =20
>=20
> 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=3Dunaligned'".  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=
.