Thread: 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... > 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/ > > ---------------------------(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/