pg_column_size() - Mailing list pgsql-general

From Jake Stride
Subject pg_column_size()
Date
Msg-id eb3ce9070609020207l59a74b2bq5385dc42315f6626@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,

I'm trying to find the size of individual rows in a database (or a subset of them) so that we can tell users how much of a quota they are using on the system (in practice this will actually be across a number of tables and I will need to write a query to do this). I have come across pg_column_size() which obviously does the size of columns. My question is do I need to use pl/pgsql and write a function to sum the columns in the rows and then the required rows - or is there something similar i.e. pg_row_size (which doesn't exist!) which I have missed.

Thanks

Jake

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Thought provoking piece on NetBSD
Next
From: Tom Lane
Date:
Subject: Re: Thought provoking piece on NetBSD