getting those pesky spaces out of a PostgreSQL select

[Sannyasin Sivakatirswami]

Len Morgan wrote:
> Can I ask why you are using psql instead of the rev functions (which 
> don't pad)?

Rev Database Functions: You Wish! We Wish!

This is the 2.6.1 engine running on a linux web server...
so, it is relatively "crippled" dBase wise.

all the power tools we would love to be able to
use on a web server installation are simply not available.

Crossing our fingers that this will all change
with 2.9....


> 
> len morgan
> 
> 
> Sadhunathan Nadesan wrote:
>> Swami
>>
>> It appears that the -A option to psql does what you want.  It's right
>> at the beginning of the man entry for psql.
>>
>> To see this in action log in to vel and cd to /tmp, then run
>>
>> psql htde -f event.sql
>>
>> It looks like this
>>
>>  user_id | event_code |     event_time      |      description
>> ---------+------------+---------------------+------------------------------------------------------------------------------------ 
>>
>> 878      | AU         | 2008-06-02 13:18:45 | user: govan at starhub.net.sg
>> 878      | VI         | 2008-06-02 13:20:28 | Hinduism Today Digital 
>> Edition July/August/September 2007
>> 878      | DB         | 2008-06-02 13:20:28 | 
>> http://www.hinduismtoday.com/archives/2007/7-9/cover_2007-07-01.jpg
>> 878      | DE         | 2008-06-02 13:20:33 | 
>> http://www.hinduismtoday.com/archives/2007/7-9/cover_2007-07-01.jpg
>>
>> next run psql -A htde -f event.sql and it looks like this
>>
>> user_id|event_code|event_time|description
>> 878|AU|2008-06-02 13:18:45|user: govan at starhub.net.sg
>> 878|VI|2008-06-02 13:20:28|Hinduism Today Digital Edition 
>> July/August/September 2007
>> 878|DB|2008-06-02 
>> 13:20:28|http://www.hinduismtoday.com/archives/2007/7-9/cover_2007-07-01.jpg 
>>
>> 878|DE|2008-06-02 
>> 13:20:33|http://www.hinduismtoday.com/archives/2007/7-9/cover_2007-07-01.jpg 
>>
>> 878|DB|2008-06-02 
>> 13:20:33|http://www.hinduismtoday.com/archives/2007/7-9/pdf/section-1_2007-07-01_p01-17.pdf 
>>
>> 878|DE|2008-06-02 
>> 13:26:33|http://www.hinduismtoday.com/archives/2007/7-9/pdf/section-1_2007-07-01_p01-17.pdf 
>>
>>
>>
>> So does that do it for you?
>>
>> Aloha,
>> Sadhu
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
>>   
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>