Quickstart
Developer experience
Version control
Blocks
Pipelines
dbt
- Overview
- Getting started
- New project
- Configuration
- Models
- Commands
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
allow_reserved_words: False
auto_clean_name: True
case_sensitive: False
Was this page helpful?
On this page