change all tables owner to specified user
danang setya pramanafirst use select to show all tables from old owner SELECT tablename, schemaname,tableowner FROM pg_tables WHERE schemaname = 'public' AND tableowner = 'oldowner'; and make script for looping alter table…
To drop all primary key constraints in the public schema of a PostgreSQL database
DO $$ DECLARE r RECORD; BEGIN -- Select all primary key constraints in the 'public' schema FOR r IN ( SELECT table_name, constraint_name FROM information_schema.table_constraints WHERE constraint_type = 'PRIMARY KEY'…
strict change column type table postgre from string to int
ALTER TABLE table_name ALTER COLUMN column_name TYPE BIGINT USING (column_name::bigint);
drizzle init for postgres nextjs
sebelumnya buat .env dan isi connection string untuk postgre POSTGRE_URL="postgresql://postgres:userpassword@localhost:5432/dbname" buat drizzle config import { defineConfig } from "drizzle-kit"; export default defineConfig({ schema: "./src/lib/db/postgresql/schema.ts", out: "./src/lib/drizzle/postgresql", dialect: "postgresql", dbCredentials: {…
migrate database from mysql to postgre using docker pg_loader
karena saya menggunakan jendela saat ini , terpaksa saya menggunakan pg_loader dari docker , pertama ambil packagenya dulu dari remote milik dimitri docker pull ghcr.io/dimitri/pgloader:latest pertama pastikan kalian punya akses…
postgre query grant & alter
mengubah privileges user untuk semua tables GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user; ubah nama field di dalam table ALTER nama_table RENAME COLUMN nama_lama TO nama_baru;…
How to use npx prisma db seed
Before running the command, ensure you have configured your project to support seeding: Define the seed script location In your package.json file, you must specify the command to run your seed script. This…
grant new user to database postgre
GRANT CONNECT ON DATABASE mydatabase TO myuser; GRANT USAGE ON SCHEMA public TO myuser; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myuser;
troubleshoot face_recognition_models unrecognized
1. Perbaiki pip & setuptools dulu Di Terminal, jalankan perintah berikut satu per satu (pakai python3 -m supaya pasti ke interpreter yang benar): bash Copy python3 -m ensurepip --upgrade python3…
location mongo db configuration
The specific path depends on your Mac's processor architecture: Apple Silicon (M1, M2, M3, etc.): /opt/homebrew/etc/mongod.conf Intel Processors: /usr/local/etc/mongod.conf