K
Kysely•12mo ago
mdthansil

How can i enable postgres Extensions (eg: uuid) with in Kysely Migration File

const query = sqlcreate extension "uuid-ossp";; how to execute this raw query inside migration file up method
Solution:
Message Not Public
Sign In & Join Server To View
Jump to solution
2 Replies
Solution
Unknown User
Unknown User•12mo ago
Message Not Public
Sign In & Join Server To View
mdthansil
mdthansil•12mo ago
Wow! Thanks man ❤️
Want results from more Discord servers?
Add your server
More Posts
Unable to insert geometry PostgresHey everyone 👋🏻 Greetings! I am trying to insert `point` data into my Postgresql table but gettAchieve Prisma-like nested selectsHi. Is it possible to achieve Prisma-like nested selects with Kysely? I have the following code and Why is numUpdatedRows a BigInt?Hi. I'd just like to ask as to why the number of updated rows in Kysely is a BigInt, as for all otheHow to translate the WITH keyword in postgres when SELECT does not have FROM?I'm trying to translate the following postgres function into pure Kysley: ```sql CREATE OR REPLACE Using column aliases in `.where()`This is a supported feature in MySQL, but having issues here: https://kyse.link/?p=s&i=xxyMrfnfJ6CjbUsing Postgres function in an insert with a field as a selectI'm trying to translate the following SQL: ```sql INSERT INTO sb.text_document_chunk (text_documentcreate role in migrationIs it possible to create a role in a migration? And to do the grants and things as part of that?How to insert JSONB types in postgres?I've looked at https://kysely-org.github.io/kysely/classes/InsertQueryBuilder.html#values and it's n