Size of data stored in bytea record?

Поиск
Список
Период
Сортировка
Искать

Size of data stored in bytea record?

От:
Carlos <Carlos@pbsinet.com>
Дата:

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

Re: Size of data stored in bytea record?

От:
Michael Fuhr <mike@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/

Re: Size of data stored in bytea record?

От:
"Carlos Oliva" <carlos@pbsinet.com>
Дата:
Thank you Michael.  I am using the BIT_LENGTH function which seems to return 
the size in bits of the stored blob
"Michael Fuhr"  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)
>

Re: Size of data stored in bytea record?

От:
Michael Fuhr <mike@fuhr.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/
FAQ