Re: Size of data stored in bytea record?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Carlos <Carlos(at)pbsinet(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Size of data stored in bytea record?
Date: 2005-01-25 22:15:01
Message-ID: 20050125221500.GA96092@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message TJ O'Donnell 2005-01-25 22:19:17 visualizing B-tree index coverage
Previous Message Martijn van Oosterhout 2005-01-25 22:03:36 Re: Delete with a multi-column join?