---
title: "Ensure Postgres Vector Extension"
slug: "ensure-postgres-vector-extension"
updated: 2025-07-01T14:38:29Z
published: 2025-07-01T14:38:29Z
canonical: "documentation.decisions.com/ensure-postgres-vector-extension"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Ensure Postgres Vector Extension

| 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](https://documentation.decisions.com/docs/ai-common) to be [installed](https://documentation.decisions.com/docs/installing-modules-decisions) 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 |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_10h05_07.png)

---

## 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.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_09h08_08.png)

---

Related Information

[AI Common Module](https://documentation.decisions.com/docs/ai-common)