Stay organized with collections
Save and categorize content based on your preferences.
This page shows you how to use AlloyDB as a vector database with
the vector extension that includes pgvector functions and operators. These
functions and operators let you store embeddings as vector values.
Required database extension
Use the vector extension, version 0.5.0.google-1 or later, which includes
pgvector functions and operators, to store generated embeddings as vector values. This
is a version of pgvector that Google has extended with optimizations specific
to AlloyDB.
CREATEEXTENSIONIFNOTEXISTSvector;
Store generated embeddings
Ensure that you have already created a table in your AlloyDB database.
To store vector embeddings, do the following:
Create a vector[] column in your table to store your embeddings:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-25 UTC."],[[["AlloyDB can be used as a vector database by utilizing the `vector` extension, which includes `pgvector` functions and operators for storing embeddings."],["The `vector` extension, version `0.5.0.google-1` or later, is required to store embeddings as `vector` values, with this specific version having been optimized by Google for AlloyDB."],["To store embeddings, add a `vector[]` column to your existing table using the `ALTER TABLE` command, specifying the table name, embedding column name, and the number of dimensions supported by the model."],["Embeddings can be copied into the newly created vector column from a `.csv` file using the `COPY` command."],["After storing embeddings, indexes can be created using the `vector` or `alloydb_scann` extension for quicker query performance."]]],[]]