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

From: JohnDz <john_dzilvelis(at)sunserv1(dot)valpak(dot)com>
To: Mehrdad Ghassempoory <ghassempoory(at)cardiff(dot)ac(dot)uk>, PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Setting the table separator in psql command mode
Date: 1998-06-09 09:51:08
Message-ID: 357D058C.59E26D40@mailhost.valpak.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 ' '

--
-----------------------------------------------------------------
|John Dzilvelis |
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-06-09 10:09:33 Re: [GENERAL] Foreign Keys
Previous Message Anton Stckl 1998-06-09 09:28:22 experiences since splitting the list