Bug #468: psql field separator......

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #468: psql field separator......
Date: 2001-09-24 09:32:44
Message-ID: 200109240932.f8O9WiF22721@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Maurizio Totti (mtotti(at)libero(dot)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(at)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hans-Juergen Schoenig 2001-09-24 10:17:42 Vacuums and bad process status
Previous Message Ana Claudia 2001-09-24 09:28:31