Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
Blog: http://raghavt.blogspot.com/



2011/10/3 姜头 <104186179@xxxxxx>
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux