pgvector.git / summary / log / commit / refs

commit    d57047a935eac270eae99fed2a48432d7638488d
Author:   Andrew Kane <andrew@ankane.org>
Date:     Fri Mar 01 04:35:01 2024 +0000

    Moved COPY example and added FORMAT [skip ci]


README.md | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/README.md b/README.md index d86faf53..8c7b8569 100644 --- a/README.md +++ b/README.md @@ -102,17 +102,17 @@ Insert vectors INSERT INTO items (embedding) VALUES ('[1,2,3]'), ('[4,5,6]'); ``` -Upsert vectors +Or load vectors in bulk using `COPY` ```sql -INSERT INTO items (id, embedding) VALUES (1, '[1,2,3]'), (2, '[4,5,6]') - ON CONFLICT (id) DO UPDATE SET embedding = EXCLUDED.embedding; +COPY items (embedding) FROM STDIN WITH (FORMAT BINARY); ``` -Load vectors in bulk using Postgres `COPY` +Upsert vectors ```sql -COPY items (id, embedding) FROM STDIN; +INSERT INTO items (id, embedding) VALUES (1, '[1,2,3]'), (2, '[4,5,6]') + ON CONFLICT (id) DO UPDATE SET embedding = EXCLUDED.embedding; ``` Update vectors [parent: f1db1f17e3cf]