| Step Details | |
| Introduced in Version | 9.3.0 |
| Last Modified in Version | 9.3.0 |
| Location | AI > Postgres AI > Vector Preparation |
The Ensure Postgres Vector Extension step is used to configure the PostgreSQL database to support vector data storage. It allows setting table and column names to store vector data in PostgreSQL. This step ensures that the necessary extensions are in place for optimal vector data management.
Prerequisites
This step requires the AI Common to be installed before it will be available in the toolbox.
Properties
Connection Settings
| Property | Description | Data Type |
|---|---|---|
| Override Vector Table Connection | Boolean enabling user to override default vector table connection | Boolean |
Query Settings
| Property | Description | Data Type |
|---|---|---|
| Vector Storage Info | Location of vector storage chosen from flow data | Flow Data |
Outputs
| Property | Description | Data Type | |
|---|---|---|---|
| Not Supported | |||
| Error Message | This output provides an error message that details any errors encountered during the process. If there are issues with the operation, this message will help identify and troubleshoot the problem. | String | |
Common Errors
Object Reference Not Set to an Instance of an Object
If the Vector Storage Info is not set, the step will cause an error.
To correct this, ensure there is valid and properly formatted vector storage info inputted.
Related Information