| From: | Gabriele Bartolini <gabriele(dot)bartolini(at)2ndQuadrant(dot)it> |
|---|---|
| To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: What is field separator? |
| Date: | 2010-05-30 08:37:12 |
| Message-ID: | 4C0223B8.6050009@2ndQuadrant.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Tena Sakai ha scritto:
> 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?
The field separatore in psql is used only when the format is "unaligned"
(which does not happen to be default).
In order for it to be effective, you need to type in psql:
\pset format unaligned
\pset fieldsep '\t'
This will give you an output with columns that are separated by tab.
However, I suggest that you look at the documentation for more options
and ways to achive the same results:
http://www.postgresql.org/docs/current/static/app-psql.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abraham, Danny | 2010-05-30 12:20:39 | How do I elimitae ANY loggin to Windows Eventlog - event the logger shutdown msg? 8.2.4. |
| Previous Message | Tena Sakai | 2010-05-30 04:19:44 | What is field separator? |