| From: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | What is field separator? |
| Date: | 2010-05-30 04:19:44 |
| Message-ID: | C8273570.AF06%tsakai@gallo.ucsf.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 “|” 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 “|” is called in my example above?
And is it possible to change it from “|” to something else for
display purpose?
Thank you.
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Bartolini | 2010-05-30 08:37:12 | Re: What is field separator? |
| Previous Message | Igor Neyman | 2010-05-29 19:56:40 | Re: Oracle's Long data type equivalent data type in Postgresql ? |