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 support@youngapp.co or request the demo with our sales team.