This PostgreSQL extension is a Foreign Data Wrapper (FDW) for GridDB.
This version of griddb_fdw can work for PostgreSQL 9.6, 10 and 11.

griddb_fdw requires GridDB's C client library. This library can be downloaded from the GridDB website on github1.

1. Preapre GridDB's C client Download GridDB's C client and unpack it into griddb_fdw directory as griddb.
   Build GridDB's C client
   -> gridstore.h should be in griddb_fdw/griddb/client/c/include.
   -> libgridstore.so should be in griddb/bin.

2. Build and install griddb_fdw Change into the griddb_fdw source directory.

$ make
$ make install

If you want to build griddb_fdw in a source tree of PostgreSQL, use

$ make NO_PGXS=1

CREATE EXTENSION griddb_fdw;

CREATE SERVER griddb_svr FOREIGN DATA WRAPPER griddb_fdw OPTIONS(host '239.0.0.1',  
port '31999', clustername 'ktymCluster');

We have to specify the following parameters for a GridDB foreign server:

host : GridDB notification addres.
port : GridDB notification port
clustername : GridDB cluster name

CREATE USER MAPPING FOR public SERVER griddb_svr OPTIONS(username 'admin', password 'testadmin');

We have to specify the following parameters for a user mapping:
username : GridDB username
password : GridDB password

IMPORT FOREIGN SCHEMA griddb_schema FROM SERVER griddb_svr INTO public;

We can use the following parameters for import schema:
recreate : 'true' or 'false'. If 'true', table schema will be updated.

After schema is imported, we can access tables.

The container must have rowkey on GridDB in order to execute update and delete query.

• Supprt SELECT and INSERT
• Supprt UPDATE and DELETE
• WHERE clauses are pushdowned

Nothing.

Copyright (c) 2017-2018, TOSHIBA Corporation
Copyright (c) 2011 - 2016, EnterpriseDB Corporation

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

See the LICENSE file for full details.