PostgreSQL

Introduction
​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.
Supported actions
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
Create row
List of fields available for Create row action in PostgreSQL connector:
Field
Type
Table
String
Values
Object
Read row
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
Update row
List of fields available for Update row action in PostgreSQL connector:
Field
Type
Table
String
Condition
Object
Values
Object
Delete row
List of fields available for Delete row action in PostgreSQL connector:
Field
Type
Table
String
Condition
Object
Count row
List of fields available for Count row action in PostgreSQL connector:
Field
Type
Table
String
Condition
Object
Run custom PostgreSQL action
List of fields available for Run custom SQL action action in PostgreSQL connector:
Field
Type
Code
Function
Setup requirements
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.
Connection 
Field
Type
Description
Host
Required
 The IP address or hostname (db.example.com) of where your database instance resides. Note, localhost and 127.0.0.1 are not valid!
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 [email protected] or request the demo with our sales team.

Last modified 3yr ago

Field	Type
Table	String
Condition	Object
Values	Object
Attributes	Object
Limit	Number
Order by	String
Order way	Desc or Asc

Field	Type	Description
Host	Required	The IP address or hostname (db.example.com) of where your database instance resides. Note, `localhost` and `127.0.0.1` are not valid!
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.)