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