How to configure PostgreSQL as a destination in Mage to write pipeline data into a PostgreSQL table using direct database credentials and optional schema/table controls.
Key | Description | Example Value | Required |
---|---|---|---|
database | Name of the PostgreSQL database where data will be written. | demo | ✅ |
host | Hostname or IP address of the PostgreSQL server. | db.bit.io | ✅ |
port | Port used by the PostgreSQL service. Default is 5432 . | 5432 | ✅ |
username | Username with access to the target database and schema. | guest | ✅ |
password | Password for the PostgreSQL user. | abc123... | ✅ |
schema | Name of the schema where the table will be created. | public | ✅ |
table | Name of the table Mage will write records into. | dim_users_v1 | ✅ |
Key | Description | Example Value |
---|---|---|
skip_schema_creation | If true , Mage will skip running CREATE SCHEMA . Use this if the schema already exists. See issue | true |
lower_case | If true , Mage will convert all column names to lowercase. Default is true . | true |
allow_reserved_words | If true , Mage will allow column names that are PostgreSQL reserved words. Default is false . | true or false |
CREATE TABLE
, INSERT
, and optionally CREATE SCHEMA
privileges.