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]