pgvector support

[elrhomariyounes]

Hello,

I was wondering if this api supports the pgvector extension.

Thank you.

[steve-chavez]

Sure, every pg extension is supported since you have full access to SQL functions through RPC.

Now if you're looking to use pgvector operators (<#>, <=>) directly through the API then that's not possible right now. But you can always use RPC as mentioned above.

(We're looking to extend operators on #2028)

[elrhomariyounes]

Awesome thank you for the response. In a simple case where I have a table :

CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3));

and I want to insert a record is this correct:

curl "http://localhost:3000/items" \
  -X POST -H "Content-Type: application/json" \
  -d '{ "embedding": [1,2,3] }'

For the operators the workaround using rpc for the moment is fine

[steve-chavez]

Yes that seems fine, inserting should work normally.

[elrhomariyounes]

Awesome thank you.

[yairyairyair]

I know it's possible via RPC but it would really help if we can also support custom operators...
It's another part to behind 100% fully possible to run any query in postgREST without some custom functions...

[yairyairyair]

Thanks in advance!