Postgres Pro
Downloads
Home   >   mailing lists

Re: Size of data stored in bytea record? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Size of data stored in bytea record?
Date
Msg-id 20050125221500.GA96092@winnie.fuhr.org
Whole thread Raw
In response to Size of data stored in bytea record?  (Carlos <Carlos@pbsinet.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Delete with a multi-column join?
Next
From: "TJ O'Donnell"
Date:
Subject: visualizing B-tree index coverage