​PostgreSQL is the open-source object-relational database management system hosted either in the cloud or on-premise. It is being used by many startups.
For your PostgreSQL account, YAP ensures the following actions:
Create row
Read row
Update row
Find row
Delete row
Count row
Run custom PostgreSQL action
List of fields available for Create row action in PostgreSQL connector:
Field | Type |
Table | String |
Values | Object |
List of fields available for Read row action in PostgreSQL connector:
Field | Type |
Table | String |
Condition | Object |
Values | Object |
Attributes | Object |
Limit | Number |
Order by | String |
Order way | Desc or Asc |
List of fields available for Update row action in PostgreSQL connector:
Field | Type |
Table | String |
Condition | Object |
Values | Object |
List of fields available for Delete row action in PostgreSQL connector:
Field | Type |
Table | String |
Condition | Object |
List of fields available for Count row action in PostgreSQL connector:
Field | Type |
Table | String |
Condition | Object |
List of fields available for Run custom SQL action action in PostgreSQL connector:
Field | Type |
Code | Function |
Before setup, please check that you have granted to YAP the permission to send notification to your PostgreSQL account. For this, sign in to PostgreSQL and authorize the permissions requested by YAP.
Field | Type | Description |
Host | Required | The IP address or hostname (db.example.com) of where your database instance resides. Note, |
Port | Required | Number field. Values will be converted into a number |
Database | Required | The name of the database you would like to interact with. |
Schema | Required | ​ |
Username | Required | We recommend creating a new database user with extremely limited access. |
Password | Optional | Again, this should not be your production password. Make it strong! (We like using random.org.) |
For more information, see PostgreSQL documentation.
Questions? We're always happy to help with any issues you might have! Send us an email to support@youngapp.co or request the demo with our sales team.