Skip to content

README.md

Latest commit

 

History

History
30 lines (23 loc) · 452 Bytes

README.md

File metadata and controls

30 lines (23 loc) · 452 Bytes
Raw

cargo pgrx run

create extension

CREATE EXTENSION PGVector;

create table

CREATE TABLE test_vectors (
    id SERIAL PRIMARY KEY,
    embedding PGVector
);

insert data

INSERT INTO test_vectors (embedding) VALUES ('{"dims": [1.0, 2.0, 3.0, 4.0]}');

query data

SELECT * FROM test_vectors;

pgvector=# SELECT * FROM test_vectors;
1 | {"dims":[1.0,2.0,3.0]}
  2 | {"dims":[1.0,2.0,3.0,4.0]}