getting those pesky spaces out of a PostgreSQL select

[Len Morgan]

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

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
>
>
>