Обсуждение:

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<!--P =
{
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
-->


<div style=3D"FONT-FAMILY: Tahoma; DIRECTION: ltr; COLOR: #000000; FONT-SIZ=
E: x-small">

Hello, =

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.
Thank you in advance
Best regards,
 
Anned

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