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

Started by PostgreSQL Bugs Listover 24 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #468: psql field separator......

Maurizio Totti (mtotti@libero.it) reports a bug with a severity of 3

The option for change the field separator in psql don't work (or I'm not able to use it :-).

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 | |

The field separator only works in the unaligned output mode (\a).

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter