Re: Size of data stored in bytea record?

Поиск
Список
Период
Сортировка
От Carlos Oliva
Тема Re: Size of data stored in bytea record?
Дата
Msg-id 10vf7aujgl05b38@corp.supernews.com
обсуждение исходный текст
Ответ на Size of data stored in bytea record?  (Carlos <Carlos@pbsinet.com>)
Ответы Re: Size of data stored in bytea record?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
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)
>



В списке pgsql-general по дате отправления:

Предыдущее
От: "Andrew L. Gould"
Дата:
Сообщение: Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)
Следующее
От: Mickael Faivre-Macon
Дата:
Сообщение: backslashes in queries containing LIKE