Re:

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re:
Дата
Msg-id CAM3SWZRvoYREQJ5RfiS1p9YiOVo_OtBrr94nnu93De1=aY1SOA@mail.gmail.com
обсуждение исходный текст
Ответ на  (Anned-Linz Senadin <anned-linz.senadin.1@ulaval.ca>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Anned-Linz Senadin
Дата:
Сообщение:
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: PostgreSQL fails to convert decomposed utf-8 to other encodings