Request a Demo
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 [email protected]
Whole thread Raw
In response to Stripping empty space from all fields in a table?  ("J B" <[email protected]>)
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 <[email protected]> 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