getting those pesky spaces out of a PostgreSQL select

[Sadhunathan Nadesan]

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