syrona_connect_pg: Connect to a PostgreSQL OMOP CDM.

In syrona: Stratified Prevalence Comparison Across OMOP CDM Datasets

Connect to a PostgreSQL OMOP CDM.

Description

For remote databases, typically accessed via SSH tunnel: ssh -L 5432:localhost:5432 user@server.

Usage

syrona_connect_pg(
  host = "localhost",
  port = 5432,
  dbname,
  user,
  password = NULL,
  cdm_schema = "public",
  write_schema = cdm_schema
)

Arguments

host	Hostname (default "localhost" for SSH tunnel).
port	Port number (default 5432).
dbname	Database name.
user	PostgreSQL username.
password	Password. If NULL, uses .pgpass or PGPASSWORD env var.
cdm_schema	Schema with OMOP CDM tables (e.g. "cdm").
write_schema	Schema for cohort/temp tables (e.g. "results_maarja").

Value

Same structure as syrona_connect.

syrona documentation built on Sept. 5, 2026, 1:06 a.m.