On Oct 27, 2006, at 12:39 PM, J B wrote:
> 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?
UPDATE foo SET bar = btrim(bar) WHERE bar != btrim(bar)
should do it. That'll trim spaces - if you have a broader definition
of whitespace you should take a look at the docs for the btrim
If this'll hit most of the rows on your table you probably want
to do a vacuum full (or a cluster) afterwards to recover all the
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2006-10-27 19:55:35|
|Subject: Re: Simple OUTER JOIN doubt |
|Previous:||From: Shoaib Mir||Date: 2006-10-27 19:46:11|
|Subject: Re: Stripping empty space from all fields in a table?|