Message-ID: <4C05F3EC.1020107@2ndquadrant.com>
Date: Wed, 02 Jun 2010 02:02:20 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Tena Sakai <tsakai@gallo.ucsf.edu>
CC: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: What is field separator?
References: <C829E86F.AF42%tsakai@gallo.ucsf.edu>
In-Reply-To: <C829E86F.AF42%tsakai@gallo.ucsf.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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