Search Postgresql Archives

Stripping empty space from all fields in a table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Stripping empty space from all fields in a table?
From: "J B" <jbwellsiv@xxxxxxxxx>
Date: Fri, 27 Oct 2006 15:39:21 -0400

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Stripping empty space from all fields in a table?
  - From: David Fetter
- Re: Stripping empty space from all fields in a table?
  - From: Bricklen Anderson
- Re: Stripping empty space from all fields in a table?
  - From: Steve Atkins
- Re: Stripping empty space from all fields in a table?
  - From: Shoaib Mir

Prev by Date: Re: plpython.so
Next by Date: DELETE performance issues
Previous by thread: Simple OUTER JOIN doubt
Next by thread: Re: Stripping empty space from all fields in a table?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux