From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
Date: Tue, 1 Jun 2010 23:05:11 -0700
Message-ID: <C82B42A7.AF6F%tsakai@gallo.ucsf.edu> (raw)
In-Reply-To: <4C05F3EC.1020107@2ndquadrant.com>
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.
>>
>>>> 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.
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, greg@2ndquadrant.com, gabriele.bartolini@2ndQuadrant.it
Subject: Re: What is field separator?
In-Reply-To: <C82B42A7.AF6F%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