Re: Size of data stored in bytea record?

From: "Carlos Oliva" <carlos(at)pbsinet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Size of data stored in bytea record?
Date: 2005-01-26 13:38:55
Message-ID: 10vf7aujgl05b38@corp.supernews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fuhr(dot)org> wrote in message
news:20050125221500(dot)GA96092(at)winnie(dot)fuhr(dot)org(dot)(dot)(dot)
> 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(at)postgresql(dot)org)
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mickael Faivre-Macon 2005-01-26 13:44:40 backslashes in queries containing LIKE
Previous Message Andrew L. Gould 2005-01-26 13:35:53 Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)