Postgres Pro
Downloads
Home   >   mailing lists

Thread: bug in psql?

bug in psql?

From
Peter Keller
Date:
Hello all,
is there a bug in psql (PostgreSQL 7.0.2 on i686-pc-linux-gnu)?
When I start psql with the command -F $ (or any other saparator) the
output is still with the separator |.
When I do a \pset in psql I get the same wrong result.

Example:
test=# \pset fieldsep $
Field separator is '$'.
test=# SELECT * from fltl;
 obnr  | objtyp |
-------+--------+
 1764a | FLTL   |
 1772a | FLTL   |

Any ideas?
Peter

--
        Bezirksfinanzdirektion Muenchen
              Vermessungsabteilung
.........................................................
 Peter Keller        :  Tel: (+49) 089-2190-2594
 Vermessungsrat z.A.:  Fax: (+49) 089-2190-2459
 Alexandrastr. 3    :  mailto:Peter.Keller@bvv.bayern.de
 80538 Muenchen        :  web: http://www.bayern.de/vermessung

Re: bug in psql?

From
Holger Klawitter
Date:
> When I start psql with the command -F $ (or any other saparator) the
> output is still with the separator |.

\f is only being honored when field alignment (\a) is turned off.
Dunno, whether this is intended.

Regards,
Mit freundlichem Gruß,
    Holger Klawitter
--
Holger Klawitter                                    +49 (0)251 484 0637
holger@klawitter.de                            http://www.klawitter.de/