PostgreSQL
Get by Name
Overview
- Introduction
- Authentication
- Examples
Endpoints
- Identities
- Token Auth
- Universal Auth
- GCP Auth
- AWS Auth
- Azure Auth
- Kubernetes Auth
- OIDC Auth
- JWT Auth
- Groups
- Organizations
- Projects
- Project Users
- Project Groups
- Project Identities
- Project Roles
- Project Templates
- Environments
- Folders
- Secret Tags
- Secrets
- Dynamic Secrets
- Secret Imports
- Secret Rotations
- Identity Specific Privilege
- App Connections
- GETList
- GETOptions
- Auth0
- AWS
- Azure App Configuration
- Azure Client Secret
- Azure Key Vault
- Camunda
- Databricks
- GCP
- GitHub
- Hashicorp Vault
- Humanitec
- LDAP
- Microsoft SQL Server
- PostgreSQL
- TeamCity
- Terraform Cloud
- Vercel
- Windmill
- GET
- Secret Syncs
- Integrations
- Service Tokens
- Audit Logs
Infisical PKI
- Certificate Authorities
- Certificates
- Certificate Templates
- Certificate Collections
- PKI Alerting
Infisical SSH
- Hosts
- Host Groups
- Certificates
- Certificate Authorities
- Certificate Templates
Infisical KMS
- Keys
- Encryption
- Signing
PostgreSQL
Get by Name
Get the specified PostgreSQL Connection by name.
GET
/
api
/
v1
/
app-connections
/
postgres
/
connection-name
/
{connectionName}
curl --request GET \
--url https://us.infisical.com/api/v1/app-connections/postgres/connection-name/{connectionName}
{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"description": "<string>",
"version": 1,
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"isPlatformManagedCredentials": false,
"credentialsHash": "<string>",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
}
}
}
Path Parameters
The name of the PostgreSQL Connection to retrieve.
Minimum length:
1
Response
200
application/json
Default Response
Available options:
postgres
Available options:
username-and-password
The hostname of the database server.
Minimum length:
1
The name of the database to connect to.
Minimum length:
1
The port number of the database.
The username to connect to the database with.
Minimum length:
1
Whether 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?
curl --request GET \
--url https://us.infisical.com/api/v1/app-connections/postgres/connection-name/{connectionName}
{
"appConnection": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"description": "<string>",
"version": 1,
"orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"createdAt": "2023-11-07T05:31:56Z",
"updatedAt": "2023-11-07T05:31:56Z",
"isPlatformManagedCredentials": false,
"credentialsHash": "<string>",
"app": "postgres",
"method": "username-and-password",
"credentials": {
"host": "<string>",
"database": "<string>",
"port": 123,
"username": "<string>",
"sslEnabled": true,
"sslRejectUnauthorized": true,
"sslCertificate": "<string>"
}
}
}