Received: from localhost (uranus.hub.org [200.46.204.60])
	by postgresql.org (Postfix) with ESMTP id 67C549F9AD7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 12:45:22 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024)
	with ESMTP id 19081-02-9 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 12:45:16 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 72F729FA001
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 12:45:13 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from n064.sc1.cp.net (smtpout0177.sc1.cp.net [64.97.136.177])
	by svr4.postgresql.org (Postfix) with ESMTP id 953745AFBEB
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 15:45:06 +0000 (GMT)
Received: from bolek.coachhouse (81.103.216.90) by n064.sc1.cp.net (7.2.069.1)
	id 45533C7C000BF816 for pgsql-sql@postgresql.org;
	Thu, 16 Nov 2006 15:38:58 +0000
Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1GkjHY-000416-00
	; Thu, 16 Nov 2006 15:36:04 +0000
Message-ID: <455C8563.9030207@numerixtechnology.de>
Date: Thu, 16 Nov 2006 15:36:03 +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
To: pgsql-sql@postgresql.org
Subject: Re: psql -F <TAB>
References: <455C4918.4020604@numerixtechnology.de>
	<20061116115812.GB19298@alvh.no-ip.org>
	<455C54FE.5090902@numerixtechnology.de>
	<455C5B6E.1070403@joeconway.com>
In-Reply-To: <455C5B6E.1070403@joeconway.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/167
X-Sequence-Number: 26819

Joe Conway wrote:
> T E Schmitz wrote:
> 
>> 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 ' '
>>>>
>>>> How can I specify a TAB character with the -F option?
> 
> Try:
>    psql -A -t -U $DBUSER -d $DB -c "$QUERY" -F $'\t'

You're a star - that does the trick!


Regards,

Tarlika Elisabeth Schmitz