How do you enable the pgvector extension in Azure Database for PostgreSQL Flexible Server?
- A It is enabled by default
- B CREATE EXTENSION vector; (correct answer)
- C Install via apt-get on the server
- D Enable in Azure portal under Extensions blade
Shortcut: Run CREATE EXTENSION vector; as a superuser in the target database. On Azure Database for PostgreSQL Flexible Server, this is supported natively without server-level changes.