> ## Documentation Index
> Fetch the complete documentation index at: https://mage-staging.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Postgres

## Basic config

```yaml theme={null}
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.

```yaml theme={null}
unique_conflict_method: UPDATE
unique_constraints:
- col1
- col2
```