Skip site navigation (1) Skip section navigation (2)

Field Separator setting not used.

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Field Separator setting not used.
Date: 2000-10-17 19:58:27
Message-ID: 200010171958.e9HJwRJ34303@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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


Responses

pgsql-bugs by date

Next:From: Nishad PrakashDate: 2000-10-17 20:51:09
Subject: Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)
Previous:From: Tom LaneDate: 2000-10-17 19:08:33
Subject: Re: SELECTs return error with oid in WHERE clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group