Postgres Pro
Downloads
Home   >   mailing lists

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

From Shoaib Mir
Subject Re: Stripping empty space from all fields in a table?
Date
Msg-id bf54be870610271246x446f34fy78a0783a43cdfd0d@mail.gmail.com
Whole thread Raw
In response to Stripping empty space from all fields in a table?  ("J B" <jbwellsiv@gmail.com>)
List pgsql-general
Tree view
You can use something like

select ltrim(string, ' ');

and

select rtrim(string, ' ');

Thanks,
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

On 10/28/06, J B <jbwellsiv@gmail.com> wrote:
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: "J B"
Date:
Subject: Stripping empty space from all fields in a table?
Next
From: Russ Brown
Date:
Subject: Re: Simple OUTER JOIN doubt