Horton

Re: [GENERAL] Setting the table separator in psql command mode

Bruce Momjian <maillist@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: john_dzilvelis@sunserv1.valpak.com (JohnDz)
Cc: ghassempoory@cardiff.ac.uk, pgsql-general@postgreSQL.org
Date: 1998-06-09T16:41:53Z
Lists: pgsql-general 
> 
> Mehrdad Ghassempoory wrote:
> > 
> > I am trying to set up the table separator (Default "|") to TAB
> > caharcter.
> > 
> > I have tried :
> > 
> > \f\t
> > \f \t
> > \f '\t'
> > 
> > Without any luck.
> > How is it done?
> 
> I found that the following works:
> 
> psql -F '	' yourdatabasename
> 
> where a tab character is inserted in between the ' ' 

6.4 will have this working as your originally expected.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)