postgres remove database
DROP DATABASE IF EXISTS database_name;
postgres remove database
DROP DATABASE IF EXISTS database_name;
drop database postgres
DROP DATABASE base_de_datos; // SI SALE ESTE MESAJE DE ERROR HAGA LOS PASOS QUE ESTAN A CONTINUACION ERROR: database "base_de_datos" is being accessed by other users SQL state: 55006 Detail: There is 1 other session using the database. ---------------------------------------------------------------------- // primer paso --------------------------------- SELECT * FROM pg_stat_activity WHERE datname = 'base_de_datos'; //segundo paso -------------------------------- SELECT pg_terminate_backend (pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'base_de_datos'; // tercer paso -------------------------------- DROP DATABASE 'base_de_datos'; // retira las comillas si no funciona DROP DATABASE base_de_datos;
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us