Postgres

Postgres is able to be used as an external data source. Either an entire database or a single table may be added as a data source.

External database

An entire Postgres database can be added using the CREATE EXTERNAL DATABASE command.

There are two equivalent formats. In both formats, database-name will be the name of the database inside GlareDB. This cannot be qualified, and must be unique across all other databases in the deployment.

External database long format

CREATE EXTERNAL DATABASE <database-name>
 FROM postgres
 [TUNNEL <tunnel-name>]
 OPTIONS (
  host = '<host>',
  port = '<port>',
  user = '<user>',
  password = '<password>',
  database = '<database>',
 );

External database long format options

External database compact format

CREATE EXTERNAL DATABASE <database-name>
 FROM postgres
 [TUNNEL <tunnel-name>]
 OPTIONS (
  connection_string = '<connection-string>',
 );

External database compact format options

External table

Adding an external table can be done through the CREATE EXTERNAL TABLE command.

There are two equivalent formats. In both formats, table-name will be the name of the database inside GlareDB. table-name may optionally be qualified with a schema name.

External table long format

CREATE EXTERNAL TABLE <table-name>
 FROM postgres
 [TUNNEL <tunnel-name>]
 OPTIONS (
  host = '<host>',
  port = '<port>',
  user = '<user>',
  password = '<password>',
  database = '<database>',
  schema = '<schema>',
  table = '<table>',
);

External table long format options

External table compact format

CREATE EXTERNAL TABLE <table-name>
 FROM postgres
 [TUNNEL <tunnel-name>]
 OPTIONS (
  connection_string = '<connection-string>',
  schema = '<schema>',
  table = '<table>',
 );

External table compact format options