nks1302-jack Posts - Answer Overflow

nks1302-jack

•Created by nks1302-jack on 2/2/2025 in #help-and-questions

PG extensions and database credentials

Hello team, I have 2 questions: 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?

5 replies

Gaming

Programming