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-08-08 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."]]],[]]