Here’s a concise message for the Supabase Discord community:Issue with VECTOR Type in Supabase
Hi everyone! 
I'm trying to create a table with a column of type VECTOR(768) for storing embeddings. Here’s the query I’m using:
CREATE TABLE interest_embeddings (
id SERIAL PRIMARY KEY,
interest_id INT REFERENCES dictionary_interests(id) ON DELETE CASCADE,
embedding VECTOR(768) NOT NULL, -- Embedding column
created_at TIMESTAMP DEFAULT NOW()
);
However, I get the following error:
ERROR: 42704: type "vector" does not exist.
I assume the VECTOR type is missing. Is there something I need to configure or enable to use this type in Supabase? Or is this related to the current plan I’m on?
Any guidance would be appreciated!
Thanks in advance for the help!
I'm trying to create a table with a column of type VECTOR(768) for storing embeddings. Here’s the query I’m using:
CREATE TABLE interest_embeddings (
id SERIAL PRIMARY KEY,
interest_id INT REFERENCES dictionary_interests(id) ON DELETE CASCADE,
embedding VECTOR(768) NOT NULL, -- Embedding column
created_at TIMESTAMP DEFAULT NOW()
);
However, I get the following error:
ERROR: 42704: type "vector" does not exist.
I assume the VECTOR type is missing. Is there something I need to configure or enable to use this type in Supabase? Or is this related to the current plan I’m on?
Any guidance would be appreciated!
Thanks in advance for the help!
