Postgres Pro
Downloads
Home   >   mailing lists

Stripping empty space from all fields in a table? - Mailing list pgsql-general

From J B
Subject Stripping empty space from all fields in a table?
Date
Msg-id bf637a8b0610271239k76fd08f4rb35980fdfacf1fd6@mail.gmail.com
Whole thread Raw
Responses Re: Stripping empty space from all fields in a table?  ("Shoaib Mir" <shoaibmir@gmail.com>)
Re: Stripping empty space from all fields in a table?  (Steve Atkins <steve@blighty.com>)
Re: Stripping empty space from all fields in a table?  (Bricklen Anderson <banderson@presinet.com>)
Re: Stripping empty space from all fields in a table?  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view
Guys,

I have a table that has various fields that have whitespace in the values. I'd like to roll through and strip the left and right whitespace out of all fields that contain strings.

Is there any easy way to do this?

Thanks!

JB

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: plpython.so
Next
From: "Shoaib Mir"
Date:
Subject: Re: Stripping empty space from all fields in a table?