Skip to content

PostgreSQL extension that provides a Foreign Data Wrapper for hash tables.

Notifications You must be signed in to change notification settings

sangli00/hash_fdw

Repository files navigation

Foreign Data Wrapper for HASH TABLE
===============================
only build postgres 9.5.3



1. Installation

$ export PATH=/usr/local/pgsql/bin/:$PATH  

make 

make install


2. Usage

##options
"key" is this table primary , value just only this table.
hash_idx default size is 8,max size is 16.


create extension hash_fdw ;

create server hash_server foreign data wrapper hash_fdw ;

create foreign table my_hash(id bigint,name text,age int) server hash_server options(key 'id',hash_idx '1');

postgres=# insert into my_hash select 1,'AnAn',26;
postgres=# insert into my_hash select 2,'L.Sang',27;

postgres=# select * from my_hash ;
 id |  name  | age 
----+--------+-----
  1 | AnAn   |  26
  2 | L.Sang |  27
(2 rows)





About

PostgreSQL extension that provides a Foreign Data Wrapper for hash tables.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published