GitHub - sangli00/pg_get_page_tuple: PostgreSQL extension get Relation BlockNumber Tuple.

sangli00 / pg_get_page_tuple Public

Notifications You must be signed in to change notification settings
Fork 1
Star 3

PostgreSQL extension get Relation BlockNumber Tuple.

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
Makefile		Makefile
README		README
pg_fuck_block--1.0.sql		pg_fuck_block--1.0.sql
pg_fuck_block.c		pg_fuck_block.c
pg_fuck_block.control		pg_fuck_block.control

Repository files navigation

Building
-----------
make 
make install 

Usage
---------
postgres=# create extension pg_fuck_block ;
CREATE EXTENSION

postgres=# create table tab(col1 bigint,col2 text,col3 timestamp);
CREATE TABLE

postgres=# insert into tab values(1,'test',now());
INSERT 0 1
postgres=# insert into tab values(2,'test1',now());
INSERT 0 1
postgres=# select * from tab;
 col1 | col2  |            col3
------+-------+----------------------------
    1 | test  | 2016-11-17 23:26:28.723014
    2 | test1 | 2016-11-17 23:26:41.987506
(2 rows)


postgres=# select pg_get_page_tuple('tab',0);
           pg_get_page_tuple
----------------------------------------
 (1,test,"2016-11-17 23:26:28.723014")
 (2,test1,"2016-11-17 23:26:41.987506")
(2 rows)