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

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

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

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

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter