Received: from localhost (uranus.hub.org [200.46.204.60])
	by postgresql.org (Postfix) with ESMTP id E17059FA19B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 14:25:02 -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 34148-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 14:24:55 -0400 (AST)
X-Greylist: delayed 01:40:12.56032 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 853D89FA111
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 14:24:55 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from smtp.oak.ocn.ne.jp (oak.ocn.ne.jp [222.146.40.104])
	by svr4.postgresql.org (Postfix) with ESMTP id 2C1305AFA86
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 16:20:20 +0000 (GMT)
Received: from [192.168.1.6] (p19223-adsau18honb3-acca.tokyo.ocn.ne.jp
	[219.165.44.223]) by smtp.oak.ocn.ne.jp (Postfix) with ESMTP
	id 31B742724; Thu, 16 Nov 2006 23:31:57 +0900 (JST)
Message-ID: <455C765D.7030504@oak.ocn.ne.jp>
Date: Thu, 16 Nov 2006 23:31:57 +0900
From: Kazuyuki Maejima <kmaejima@oak.ocn.ne.jp>
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: T E Schmitz <mailreg@numerixtechnology.de>
Cc: 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-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50,
	UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200611/169
X-Sequence-Number: 26821

Joe Conway wrote:
> Try:
>    psql -A -t -U $DBUSER -d $DB -c "$QUERY" -F $'\t'

That's excellent, but please let me post a different way :)
by passing commands from stdin:

#!/bin/sh
cat <<EOT | psql -q -A -t -U $DBUSER -d $DB
\f '\t'
$QUERY
EOT

I think this will work even if your /bin/sh is not bash
(like FreeBSD and NetBSD).

Cheers,
Kazuyuki