DB::POSTGRESQL

Establish connection to PostGresql Database.

Syntax

resources:
  <resource-id>:
    type: DB::POSTGRESQL
    props:
      host: <host>
      port: <port>
      dbName: <database-name>
      username: <username>
      password: <password>

Properties

Property	Description	Type
<resource-id>	Unique identifier for the resource	string
type	Type of the resource	string
props	Properties specific to this resource. Refer to props section for more details.	object

props

Property	Description	Required
host	Hostname or IP address of the database server	true
port	Port number of the database server	true
dbName	Name of the database to connect to	true
username	Username for the database authentication	true
password	Password for the database authentication	true

Example

resources:
  mysqlDb:
    type: DB::POSTGRESQL
    props:
      username: admin
      password: password123
      host: localhost
      port: 5432
      dbName: db_name