Skip to content

Latest commit

 

History

History
28 lines (22 loc) · 721 Bytes

adding-catalog.md

File metadata and controls

28 lines (22 loc) · 721 Bytes

Adding a catalog into Trino

Postgres example

Postgres connector

CREATE CATALOG example USING postgresql
WITH (
  "connection-url" = 'jdbc:pg:localhost:5432',
  "connection-user" = '${ENV:POSTGRES_USER}',
  "connection-password" = '${ENV:POSTGRES_PASSWORD}',
  "case-insensitive-name-matching" = 'true'
);

Live Example

CREATE CATALOG <name-of-catalog> USING <connector-name>
WITH (
  "connection-url" = 'jdbc:postgresql://192.168.6.100:5432/70ld_db',
  "connection-user" = 'paul',
  "connection-password" = 'password'
);