| From: | "Jake Stride" <jake(dot)stride(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_column_size() |
| Date: | 2006-09-02 09:07:51 |
| Message-ID: | eb3ce9070609020207l59a74b2bq5385dc42315f6626@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | timasmith | 2006-09-02 12:31:18 | One step install, up and running? |
| Previous Message | Shane Ambler | 2006-09-02 07:35:42 | Re: Thought provoking piece on NetBSD |