Quick Links

Stripping empty space from all fields in a table?

From:	"J B" <jbwellsiv(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Stripping empty space from all fields in a table?
Date:	2006-10-27 19:39:21
Message-ID:	bf637a8b0610271239k76fd08f4rb35980fdfacf1fd6@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: Stripping empty space from all fields in a table? at 2006-10-27 19:46:11 from Shoaib Mir
Re: Stripping empty space from all fields in a table? at 2006-10-27 19:47:29 from Steve Atkins
Re: Stripping empty space from all fields in a table? at 2006-10-27 21:56:43 from Bricklen Anderson
Re: Stripping empty space from all fields in a table? at 2006-10-28 00:21:47 from David Fetter

Browse pgsql-general by date

	From	Date	Subject
Next Message	Schwenker, Stephen	2006-10-27 19:40:51	DELETE performance issues
Previous Message	Devrim GUNDUZ	2006-10-27 19:37:18	Re: plpython.so