Re: - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re:
Date
Msg-id CAM3SWZRvoYREQJ5RfiS1p9YiOVo_OtBrr94nnu93De1=aY1SOA@mail.gmail.com
Whole thread Raw
In response to  (Anned-Linz Senadin <anned-linz.senadin.1@ulaval.ca>)
List pgsql-bugs
On Tue, Aug 5, 2014 at 5:23 PM, Anned-Linz Senadin
<anned-linz.senadin.1@ulaval.ca> wrote:
> I am a student at Laval University using PosgreSQL in work paper. So Would
> like to know if there a way or a SQL to calculate the size of a record in a
> table. I tried to use VSIZE used in Oracle but PostgreSQL is not regognized
> this function.

This is the kind of question that would be better suited to pgsql-general.

I think pg_column_size() is what you're looking for. Note that issues
like alignment, and page storage overhead are likely to obscure things
if you're considering overall on-disk storage.

--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Anned-Linz Senadin
Date:
Subject:
Next
From: Craig Ringer
Date:
Subject: Re: PostgreSQL fails to convert decomposed utf-8 to other encodings