---
title: "GET /api/v1/app-connections/postgres/{connectionId}"
method: GET
path: "/api/v1/app-connections/postgres/{connectionId}"
tags: ["App Connections"]
---

# GET /api/v1/app-connections/postgres/{connectionId}

`GET /api/v1/app-connections/postgres/{connectionId}`

Get the specified PostgreSQL Connection by ID.

## Path parameters

- `connectionId` string, uuid, required

## Response `200`

Default Response

- object
  - `appConnection` object, required
    - `id` string, uuid, required
    - `name` string, required
    - `description` string, nullable
    - `version` number
    - `orgId` string, uuid, required
    - `createdAt` string, date-time, required
    - `updatedAt` string, date-time, required
    - `isPlatformManagedCredentials` boolean, nullable
    - `gatewayId` string, uuid, nullable
    - `projectId` string, nullable
    - `isAutoRotationEnabled` boolean
    - `gatewayPoolId` string, uuid, nullable
    - `rotation` object — The credential rotation configuration, if configured.
      - `lastRotationMessage` string, nullable — The message from the last rotation attempt.
      - `rotationInterval` number, required — The interval in days between credential rotations.
      - `nextRotationAt` string, date-time, nullable — The next scheduled rotation time.
      - `rotationStatus` 'success' | 'failed', required — The status of the last rotation attempt.
      - `rotateAtUtc` object, required — The UTC time of day at which rotation should occur.
        - `hours` number, required — The hour (0-23) at which to rotate.
        - `minutes` number, required — The minute (0-59) at which to rotate.
    - `credentialsHash` string
    - `project` object, nullable
      - `name` string, required
      - `id` string, required
      - `type` string, required
      - `slug` string, required
    - `app` 'postgres', required
    - `method` 'username-and-password', required
    - `credentials` object, required
      - `host` string, required — The hostname of the database server.
      - `database` string, required — The name of the database to connect to.
      - `port` number, required — The port number of the database.
      - `username` string, required — The username to connect to the database with.
      - `sslEnabled` boolean, required — Whether or not to use SSL when connecting to the database.
      - `sslRejectUnauthorized` boolean, required — Whether or not to reject unauthorized SSL certificates.
      - `sslCertificate` string — The SSL certificate to use for connection.

## Other responses

- `400` — Default Response
- `401` — Default Response
- `403` — Default Response
- `404` — Default Response
- `422` — Default Response
- `500` — Default Response

---

[API](https://skmtc.net/infisical/apis/infisical-api.md) · [All operations](https://skmtc.net/infisical/apis/infisical-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/infisical/infisical-api/versions/f10a4f8c1d41/schema)