2

Data is stored over pages and not necessarily one row or one column or one attribute maps to one page. Is it possible to use some query to extract data from a specific page in a database environment?

  • Are you asking for SQL Server as well as Postgres? – Erik Darling Apr 5 '17 at 23:13
  • No, I am interested to see if postgresql can offer this interaction maybe through some extension as pageinspect – audlift-bit Apr 7 '17 at 18:42
1

pageinspect module

Using PostgreSQL, there is an extension that does all of this. Your question is vague so I won't even try to address the particulars here, nor is it reasonable to enumerate everything this extension does, perhaps it's enough to say that it has 17 functions and as far as I know includes all of the mechanisms available to end users to introspect pages (not saying it does everything you want).

You may want to read Database Page Layout

  • Thanks, that extension is close to what I'm looking for: I would like to see contents of pages. Something which is odd though is that there does not seem to be any functions for working with GiST index - why? – audlift-bit Apr 7 '17 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.