Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 4D602632712
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Jun 2010 02:32:21 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 75188-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Jun 2010 05:32:14 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.egcrc.net (mail.egcrc.net [63.193.204.10])
	by mail.postgresql.org (Postfix) with ESMTP id 2B2E7633110
	for <pgsql-admin@postgresql.org>; Tue,  1 Jun 2010 02:32:14 -0300 (ADT)
Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org
	([fe80::5c82:4343:5244:a0d5%11]) with mapi;
	Mon, 31 May 2010 22:32:13 -0700
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: Gabriele Bartolini <gabriele.bartolini@2ndquadrant.it>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Mon, 31 May 2010 22:29:51 -0700
Subject: Re: What is field separator?
Thread-Topic: [ADMIN] What is field separator?
Thread-Index: AcsBPsbJICbR3uLjTX6u/b9tl/rQ1QADK5jI
Message-ID: <C829E8DF.AF45%tsakai@gallo.ucsf.edu>
In-Reply-To: <1275364687-sup-2201@alvh.no-ip.org>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5
	tests=BAYES_20=-0.001
X-Spam-Level: 
X-Archive-Number: 201006/4
X-Sequence-Number: 34782

Thank you, Alvaro.

Literal tab, that's one thing I never tried.
Yes, it works.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


On 5/31/10 8:58 PM, "Alvaro Herrera" <alvherre@commandprompt.com> wrote:

> Excerpts from Tena Sakai's message of lun may 31 21:36:41 -0400 2010:
>=20
>> But when I do this:
>>   $ echo "select marker, p, afreq from gallo.fbat_sdsdecode limit 10" | =
\
>>> psql -P 'format=3Dunaligned' -P 'fieldsep=3D\t' -t -f - musket
>> (here the only change from the previous is the specification of fieldsep=
)
>> Then I get:
>>   RS3094315\t0.578121\t0.735
>=20
> Use a literal tab.  You can enter this in decent shells with Ctrl-V follo=
wed
> by a tab.