Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 45ADF9F9DAD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 08:24:07 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 15927-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 08:24:02 -0400 (AST)
X-Greylist: delayed 01:03:53.372481 by SQLgrey-
Received: from dougal.cranntara.net (unknown [217.112.91.201])
	by postgresql.org (Postfix) with ESMTP id B248A9F9EF0
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 08:24:01 -0400 (AST)
Received: from client-13-p-1-lns.glfd.dial.virgin.net ([81.103.144.12]
	helo=bolek.coachhouse)
	by dougal.cranntara.net with asmtp (Exim 3.36 #1 (Debian))
	id 1GkgJN-0008FV-00
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 12:25:46 +0000
Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1Gkg3j-0003rn-00
	; Thu, 16 Nov 2006 12:09:35 +0000
Message-ID: <455C54FE.5090902@numerixtechnology.de>
Date: Thu, 16 Nov 2006 12:09:34 +0000
From: T E Schmitz <mailreg@numerixtechnology.de>
Reply-To: mailreg@numerixtechnology.de
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
CC: pgsql-sql@postgresql.org
Subject: Re: psql -F <TAB>
References: <455C4918.4020604@numerixtechnology.de>
	<20061116115812.GB19298@alvh.no-ip.org>
In-Reply-To: <20061116115812.GB19298@alvh.no-ip.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.169 tagged_above=0 required=5 tests=AWL, BAYES_50,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200611/164
X-Sequence-Number: 26816

Alvaro Herrera wrote:
> T E Schmitz wrote:
> 
>>I have written a shell script to export data:
>>
>>psql -A -t -U $DBUSER -d $DB -c "$QUERY" -F ' '
>>
>>Currently, I am using spaces as field separator but what I really want 
>>is tabs.
>>
>>How can I specify a TAB character with the -F option?
> 
> 
> This is really a shell question.  On those I know, you'd type ^V <tab>.

True.
Ctrl-V <tab> works fine on the command-line.

> (Maybe it would work to use '\t' as well, not sure if psql interprets
> that.)

Unfortunately, it doesn't. As far as I know -F literally wants a <tab. 
character and how I get it in really is a shell question.

Sorry for having gone off-topic. I was just hoping something like \t 
could be passed, too.

-- 


Regards,

Tarlika Elisabeth Schmitz