Re: fied separator change from the shell command line - Mailing list pgsql-general

From Edmund Bacon
Subject Re: fied separator change from the shell command line
Date
Msg-id m3ll8v32p0.fsf@elb_lx.onesystem.ca
Whole thread Raw
In response to fied separator change from the shell command line  (paulo.oliveira@engineer.com)
Responses Re: fied separator change from the shell command line  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
paulo.oliveira@engineer.com writes:

> Hello,
>
> I'm trying to change the usal "|" table field separator from the shell
> command line:
> psql -d ect -f pl_lost.sql -o pl_lost.out.txt  -F "\t" -U asaadmin
>
> But it doesn't work. It keeps the same "|" separator in the output
> file.
> Can anyone please help me?
> I need to output to a tab separated file. Can anynone hel me with this?
>
> Thanks in advance,

Changing the field separator only works with unaligned output. You
need to add a -A to your command line switches (or --no-align). Doing
this, though, drops the column headers.


--
Remove -42 for email

pgsql-general by date:

Previous
From: Libo Luo
Date:
Subject: German umlauts problem (under WindowsXP, COBOL programm)
Next
From: Janning Vygen
Date:
Subject: normal user dump gives error because of plpgsql