Postgres Pro
Downloads
Home   >   mailing lists

How to trim Bytea fields - Mailing list pgsql-general

From Howard Cole
Subject How to trim Bytea fields
Date
Msg-id 438332C2.6070301@selestial.com
Whole thread Raw
Responses Re: How to trim Bytea fields  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Tree view 
Hi,

I have an bytea field that contains data with a lot of trailing blank
space composed of multiple '\000' zero bytes. Does anyone know of a
quick SQL fix to trim these bytes from the data?

Thanks

Howard Cole
http://www.selestial.com

pgsql-general by date:

Previous
From: Jacek Balcerski
Date:
Subject: problem with GRANT postgres 8.0.4
Next
From: Richard Huxton
Date:
Subject: Re: Java, postgres and jasper help