Field Separator setting not used.

Kevin Colagio (kevin(dot)colagio(at)usa(dot)xerox(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Field Separator setting not used.

Long Description

(This is major because I have about 20 scripts that I would have to modify to get this to work...and I don't think I am the only one who uses this functionality.)

I have scripts that call the following:

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

I have also tried:
psql servicedesk
\pset fieldsep ###

And that doesn't work either. It responds as if it accepts it, but doesn't use it when printing out.

The OS is Solaris 2.8 and the version of PostgreSql is 7.0.2 .

Anything else I can help with, let me know.

Thanks.

Sample Code

No file was uploaded with this report