Re: How can i get record by data block not by sql?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: How can i get record by data block not by sql?
Дата
Msg-id CA+h6Ahh51M9-0A2U4WVSx67WYHPrNUxafR2Qq6F7Sj=ax5XuDg@mail.gmail.com
обсуждение исходный текст
Ответ на How can i get record by data block not by sql?  ("姜头" <104186179@qq.com>)
Список pgsql-general
Дерево обсуждения
To know the page and row information :

Select ctid,* from <tablename>;

For more information at page-level, you can take the help of contrib module "pageinspect". Which is under pgsql-path/share/postgresql/contrib/pageinspect.sql

---
Regards,
Raghavendra
EnterpriseDB Corporation



2011/10/3 姜头 <104186179@qq.com>
How can i get record by data block not by sql?
 
I want to read and write lots of data by data blocks, so i can form a disk-resident tree by recording the block address. But i don't know  how to implement in postgresql.
Is there system function can do this? 
Can someone help me?? Thank you very very much!!!!1

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

Предыдущее
От: Karl Wright
Дата:
Сообщение: Re: [BUGS] One-click installer, Windows 7 32-bit, and icacls.exe
Следующее
От: Dave Page
Дата:
Сообщение: Re: [BUGS] One-click installer, Windows 7 32-bit, and icacls.exe