pg_column_size()

Поиск
Список
Период
Сортировка
От Jake Stride
Тема pg_column_size()
Дата
Msg-id eb3ce9070609020207l59a74b2bq5385dc42315f6626@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Thought provoking piece on NetBSD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Thought provoking piece on NetBSD