Foreign Data Wrapper

Overview

In the spirit of the PostgreSQL FDW implementation, CrateDB offers the possibility to access database tables on remote database servers as if they would be stored within CrateDB.

About

Foreign Data Wrappers allow you to make data in foreign systems available as tables within CrateDB. You can then query these foreign tables like regular user tables.

Reference Manual

• Foreign Data Wrappers

SQL Functions

• CREATE SERVER

• DROP SERVER

• CREATE FOREIGN TABLE

• DROP FOREIGN TABLE

System Tables

• foreign_servers

• foreign_server_options

• foreign_tables

• foreign_table_options

• user_mappings

• user_mapping_options

SQL FDW

Synopsis

Connect to a remote PostgreSQL server.

CREATE SERVER my_postgresql
FOREIGN DATA WRAPPER jdbc
OPTIONS (url 'jdbc:postgresql://example.com:5432/')

Mount a database table.

CREATE FOREIGN TABLE doc.remote_documents (name text)
SERVER my_postgresql
OPTIONS (schema_name 'public', table_name 'documents');

Note

This page is currently under construction. It includes not even the most basic essentials, and needs expansion. For example, the “Details”, “Usage” and “Learn” sections are missing completely.

See also

Product: Relational Database