Size of data stored in bytea record?
Is there a way that I can find out the size of a bytea record? I am storing
images into bytea fields and I just want to know the size of the image that
it has been saved in the field
On Tue, Jan 25, 2005 at 04:58:33PM -0500, Carlos wrote:
Is there a way that I can find out the size of a bytea record? I am storing
images into bytea fields and I just want to know the size of the image that
it has been saved in the field
See the "Binary String Functions and Operators" section of the
"Functions and Operators" chapter in the documentation:
http://www.postgresql.org/docs/8.0/static/functions-binarystring.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Thank you Michael. I am using the BIT_LENGTH function which seems to return
the size in bits of the stored blob
"Michael Fuhr" <mike@fuhr.org> wrote in message
news:20050125221500.GA96092@winnie.fuhr.org...
Show quoted text
On Tue, Jan 25, 2005 at 04:58:33PM -0500, Carlos wrote:
Is there a way that I can find out the size of a bytea record? I am
storing
images into bytea fields and I just want to know the size of the image
that
it has been saved in the fieldSee the "Binary String Functions and Operators" section of the
"Functions and Operators" chapter in the documentation:http://www.postgresql.org/docs/8.0/static/functions-binarystring.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
On Wed, Jan 26, 2005 at 08:38:55AM -0500, Carlos Oliva wrote:
Thank you Michael. I am using the BIT_LENGTH function which seems to return
the size in bits of the stored blob
Do you need the length in bits? If not, then one of the other
functions in the documentation I referenced might be closer to
what you seek.
http://www.postgresql.org/docs/8.0/static/functions-binarystring.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/