Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.mage.ai/llms.txt

Use this file to discover all available pages before exploring further.

​
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