# PostgresConnection

Postgres can be used to store vector data and retrieve embeddings.


## Fields

| Field                                                                                | Type                                                                                 | Required                                                                             | Description                                                                          | Example                                                                              |
| ------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------ |
| `credentials`                                                                        | [models.DestinationPgvectorCredentials](../models/destinationpgvectorcredentials.md) | :heavy_check_mark:                                                                   | N/A                                                                                  |                                                                                      |
| `database`                                                                           | *str*                                                                                | :heavy_check_mark:                                                                   | Enter the name of the database that you want to sync data into                       | AIRBYTE_DATABASE                                                                     |
| `default_schema`                                                                     | *str*                                                                                | :heavy_check_mark:                                                                   | Enter the name of the default schema                                                 | AIRBYTE_SCHEMA                                                                       |
| `host`                                                                               | *str*                                                                                | :heavy_check_mark:                                                                   | Enter the account name you want to use to access the database.                       | AIRBYTE_ACCOUNT                                                                      |
| `port`                                                                               | *int*                                                                                | :heavy_check_mark:                                                                   | Enter the port you want to use to access the database                                | 5432                                                                                 |
| `username`                                                                           | *str*                                                                                | :heavy_check_mark:                                                                   | Enter the name of the user you want to use to access the database                    | AIRBYTE_USER                                                                         |