| From: | Peter Geoghegan <pg(at)heroku(dot)com> |
|---|---|
| To: | Anned-Linz Senadin <anned-linz(dot)senadin(dot)1(at)ulaval(dot)ca> |
| Cc: | "jdrake(at)postgresql(dot)org" <jdrake(at)postgresql(dot)org>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, "selena(at)postgresql(dot)org" <selena(at)postgresql(dot)org> |
| Subject: | Re: |
| Date: | 2014-08-06 01:33:46 |
| Message-ID: | CAM3SWZRvoYREQJ5RfiS1p9YiOVo_OtBrr94nnu93De1=aY1SOA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Aug 5, 2014 at 5:23 PM, Anned-Linz Senadin
<anned-linz(dot)senadin(dot)1(at)ulaval(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2014-08-06 03:54:32 | Re: PostgreSQL fails to convert decomposed utf-8 to other encodings |
| Previous Message | Tom Lane | 2014-08-06 01:14:35 | Re: PostgreSQL fails to convert decomposed utf-8 to other encodings |