No title
<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body ocsi="x">
<div style="FONT-FAMILY: Tahoma; DIRECTION: ltr; COLOR: #000000; FONT-SIZE: x-small">
<div></div>
<div dir="ltr"><font color="#000000" size="2" face="Tahoma">Hello, </font></div>
<div dir="ltr"><font color="#000000" size="2" face="Tahoma">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.</font></div>
<div dir="ltr"><font face="tahoma">Thank you in advance</font></div>
<div dir="ltr"><font face="tahoma">Best regards,</font></div>
<div dir="ltr"><font face="tahoma"></font> </div>
<div dir="ltr"><font face="tahoma">Anned</font></div>
</div>
</body>
</html>
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs