[EMAIL PROTECTED] writes:
> psql -t -q -d servicedesk -F '###' -c "select * from users"
>
> The output should be along the lines of:
>
> abc123###Kevin###Colagio###820###209###x56469
>
> Which is then parsed by a perl program...but instead, it comes up as:
>
> abc123 | Kevin | Colagio | 820 | 209 | x56469
You need to set the output mode to unaligned, e.g., using the -A option.
Quoth the documentation:
\pset parameter [ value ]
...
format Sets the output format to one of unaligned,
aligned, html, or latex. Unique abbrevia
tions are allowed. (That would mean one let
ter is enough.)
``Unaligned'' writes all fields of a tuple
on a line, separated by the currently active
field separator. This is intended to create
output that might be intended to be read in
by other programs (tab-separated, comma-sep
arated).
...
fieldsep
Specifies the field separator to be used in
unaligned output mode. That way one can cre
ate, for example, tab- or comma-separated
output, which other programs might prefer.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
