I was trying to get Mem0 hooked up in a Python Code block and I noticed the Retool DB has the vector extension added
SELECT *
FROM pg_extension;
are we able to create vector tables/columns directly?
CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3));
or
ALTER TABLE items ADD COLUMN embedding vector(3);
I didn't want to mess up the DB accidently by trying it out
