Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id CDC8463367E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 30 May 2010 01:22:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 49167-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 30 May 2010 04:22:16 +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 5F3256323B8
	for <pgsql-admin@postgresql.org>; Sun, 30 May 2010 01:22:16 -0300 (ADT)
Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org
	([fe80::5c82:4343:5244:a0d5%11]) with mapi;
	Sat, 29 May 2010 21:22:13 -0700
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Sat, 29 May 2010 21:19:44 -0700
Subject: What is field separator?
Thread-Topic: What is field separator?
Thread-Index: Acr/r1TEROCzDOZ0QrCUJRzhYsQfhQ==
Message-ID: <C8273570.AF06%tsakai@gallo.ucsf.edu>
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: multipart/alternative;
	boundary="_000_C8273570AF06tsakaigalloucsfedu_"
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201005/289
X-Sequence-Number: 34762

--_000_C8273570AF06tsakaigalloucsfedu_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi Everybody,

I am a bit confused about field separator.
In psql, \pset command lets me change this value from the default
to something else.  I thought field separator was =93|=94 below:

  marker   | allele | afreq | fam_ |    p
------------+--------+-------+------+----------
 RS2312724  | 2      | 0.125 | 25   | 0.271484
 RS1020382  | 2      | 0.417 | 69   | 0.609682
 RS11878315 | 2      | 0.335 | 64   | 0.354771

Can somebody please tell me what =93|=94 is called in my example above?
And is it possible to change it from =93|=94 to something else for
display purpose?

Thank you.

Tena Sakai
tsakai@gallo.ucsf.edu

--_000_C8273570AF06tsakaigalloucsfedu_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html><head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252"><title>What is field separator?</title>
</head>
<body>
<font face=3D"Courier New"><span style=3D"font-size:11pt">Hi Everybody,<br>
<br>
I am a bit confused about field separator.<br>
In psql, \pset command lets me change this value from the default<br>
to something else. &nbsp;I thought field separator was =93|=94 below:<br>
</span></font><span style=3D"font-size:11pt"><font face=3D"Calibri, Verdana=
, Helvetica, Arial"><br>
</font><font face=3D"Courier New"> &nbsp;&nbsp;marker &nbsp;&nbsp;| allele =
| afreq | fam_ | &nbsp;&nbsp;&nbsp;p<br>
------------&#43;--------&#43;-------&#43;------&#43;---------- &nbsp;&nbsp=
;&nbsp;<br>
&nbsp;RS2312724 &nbsp;| 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 0.125 | 25 &nbsp;=
&nbsp;| 0.271484 <br>
&nbsp;RS1020382 &nbsp;| 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 0.417 | 69 &nbsp;=
&nbsp;| 0.609682 <br>
&nbsp;RS11878315 | 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 0.335 | 64 &nbsp;&nbsp=
;| 0.354771 <br>
<br>
Can somebody please tell me what =93|=94 is called in my example above?<br>
And is it possible to change it from =93|=94 to something else for<br>
display purpose?<br>
<br>
Thank you.<br>
<br>
Tena Sakai<br>
<a href=3D"tsakai@gallo.ucsf.edu">tsakai@gallo.ucsf.edu</a></font></span>
</body>
</html>


--_000_C8273570AF06tsakaigalloucsfedu_--