Bug #468: psql field separator...... - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #468: psql field separator......
Date
Msg-id 200109240932.f8O9WiF22721@hub.org
Whole thread Raw
Responses Re: Bug #468: psql field separator......  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Maurizio Totti (mtotti@libero.it) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
psql field separator......

Long Description
The option for change the field separator in psql don't work (or I'm not able to use it :-).
I tried whit -F ';' or -P fieldsep=';' or in interactive mode with \f ';' or \pset fieldsep ';' etc. but nothing.
The old version (7.0.3) works fine.
Tanks.

Sample Code
a427137@prometeo:~$ psql -F ';' -c "select * from sd_tab_software" sdlog
 softid |     software     |       pack
--------+------------------+------------------
      5 | AMM_ALL          | Server
      6 | ANF              | Client
      7 | ANF              | srv-ins
      8 | AOI2.51          | Server
[snip.......]
    251 | W_SIFITES_ESE    | PE_CS_I
    252 | W_SIFITES_ESE    | SD_SR_I
    253 |                  |
(254 rows)

OR

sdlog=# select * from sd_tab_software; \pset fieldsep ';'
 softid |     software     |       pack
--------+------------------+------------------
      5 | AMM_ALL          | Server
      6 | ANF              | Client
[snip.....]
    251 | W_SIFITES_ESE    | PE_CS_I
    252 | W_SIFITES_ESE    | SD_SR_I
    253 |                  |
(254 rows)

Field separator is ';'.

!!!!! The program get the option correctly, but the output is the default.
Tanks

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: "Billy G. Allie"
Date:
Subject: Re: Bug #467: Can't insert a value of 0 (zero) into a Bytea
Next
From: Kevin Way
Date:
Subject: Crash caused by CHECK on child