curl --request PATCH \
--url https://us.infisical.com/api/v1/app-connections/postgres/{connectionId} \
--header 'Content-Type: application/json' \
--data '
{
"credentials": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"password": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"name": "<string>",
"description": "<string>",
"isPlatformManagedCredentials": true,
"gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
'{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"description": "<string>",
"version": 1,
"isPlatformManagedCredentials": false,
"gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"projectId": "<string>",
"credentialsHash": "<string>",
"project": {
"name": "<string>",
"id": "<string>",
"type": "<string>",
"slug": "<string>"
}
}
}Update the specified PostgreSQL Connection.
curl --request PATCH \
--url https://us.infisical.com/api/v1/app-connections/postgres/{connectionId} \
--header 'Content-Type: application/json' \
--data '
{
"credentials": {
"host": "<string>",
"port": 123,
"database": "<string>",
"username": "<string>",
"password": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"name": "<string>",
"description": "<string>",
"isPlatformManagedCredentials": true,
"gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
'{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
},
"description": "<string>",
"version": 1,
"isPlatformManagedCredentials": false,
"gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"projectId": "<string>",
"credentialsHash": "<string>",
"project": {
"name": "<string>",
"id": "<string>",
"type": "<string>",
"slug": "<string>"
}
}
}The ID of the PostgreSQL Connection to be updated.
The credentials used to connect with PostgreSQL.
Show child attributes
The hostname of the database server.
1The port number of the database.
The name of the database to connect to.
1The username to connect to the database with.
1The password to connect to the database with.
1Whether or not to use SSL when connecting to the database.
Whether or not to reject unauthorized SSL certificates.
The SSL certificate to use for connection.
The updated name of the PostgreSQL Connection. Must be slug-friendly.
1 - 64The updated description of the PostgreSQL Connection.
256Whether or not the PostgreSQL Connection credentials should be managed by Infisical. Once enabled this cannot be reversed.
The Gateway ID to use for this connection.
Default Response
Show child attributes
postgres username-and-password Show child attributes
The hostname of the database server.
1The name of the database to connect to.
1The port number of the database.
The username to connect to the database with.
1Whether or not to use SSL when connecting to the database.
Whether or not to reject unauthorized SSL certificates.
The SSL certificate to use for connection.
Was this page helpful?