PostgreSQL
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
PostgreSQL can be used as an input and/or an output.
Syncing mode
- Add data (Insert)
- Update and Insert data (Upsert)
- Erase and Replace data (Drop)
Setup
To configure PostgreSQL connector:
-
Give a name to your connector
![[PostgreSQL] - Connector Name](https://documentator.s3.eu-west-3.amazonaws.com/143/%5BPostgreSQL%5D---Connector-Name.png)
-
Fill URL, port and other information that RestApp needs in order to connect to your PostgreSQL database
![[PostgreSQL] - Other info](https://documentator.s3.eu-west-3.amazonaws.com/144/%5BPostgreSQL%5D---Other-info.png)
-
Test the connection and be sure it is successfull
![[All connectors] - Test successfull](https://documentator.s3.eu-west-3.amazonaws.com/137/%5BAll-connectors%5D---Test-successfull.png)