Destinations
Postgres
Basic config
connector_type: postgres
database: database
host: host
password: password
port: 5432
schema: schema
username: username
table: table
Upsert record
To upsert records to Postgres, you can define unique_conflict_method
and unique_constraints
params
in the config.
unique_conflict_method: UPDATE
unique_constraints:
- col1
- col2