Who can use this feature?
👤 Available on all plans.
Connect to our read & write PostgreSQL connector to create apps with data from your database.
Click App Settings
Click Add next to the PostgreSQL option
Enter username, password, and other information.
If you want the PostgreSQL data connector to be read-only, toggle on Mark data connection read-only.
Click Test connection to connect your PostgreSQL database
Once your connection test is successful, click Save Connection to create your PostgreSQL data connection
Note
If we can't import any fields or tables (see below under Considerations) you will see a screen explaining which fields and tables have been skipped.
The PostgreSQL read/write connector has a few limitations.
The PostgreSQL connector will only import 50,000 records per table into your Stacker app.
Tables with multiple primary keys are currently only read-only.
PostgreSQL views are read-only.
We do not support all field types. Field types that are not supported are not imported, and you will not see them within your Stacker app. You can see what fields are not supported in the pop-up after initial schema sync.
If any values of the first field are NULL, syncing data for views can fail if any values of the first column are NULL