4.3 Link H2GIS with PostGIS

Link H2GIS with a PostGIS database

If you want to link a PostGIS database with H2GIS (since v1.2.3), you just have to run this sql request:

CREATE LINKED TABLE MY_TABLE ('org.orbisgis.postgis_jts_osgi.Driver',
 'jdbc:postgresql_h2://ip_adress:port/db_name','login','password','schema','table');

Where

• ip_adress is the url of your PostGIS database,
• port is the number of the server port (eg. 5432),
• schema is the schema name
• table is the table name

Remark : the "LINKED TABLE" function is based on the H2Database grammar. More details HERE.