PG extensions and database credentials
Hello team, I have 2 questions:
1) I added
but there was an error: pgvector and pgcrypto do not exist in your server, make sure to run or add them before using them.
1) How can I add extensions like pgvector, pgcrypto, etc ?
2) Where can I get the database credentials ( Host, User, Password, Database name), since the URL does not have those?
1) I added
generator client {
provider = "prisma-client-js"
previewFeatures = ["postgresqlExtensions"]
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
extensions = [pgvector(map: "vector"), pgcrypto]
}but there was an error: pgvector and pgcrypto do not exist in your server, make sure to run or add them before using them.
1) How can I add extensions like pgvector, pgcrypto, etc ?
2) Where can I get the database credentials ( Host, User, Password, Database name), since the URL does not have those?
