How To Delete or Drop PostgreSQL Database Using pgAdmin And SQL Shell psql || PostgreSQL Tutorials

Описание

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360. Here I post technical videos, mainly related to computer science and programming. I am posting project videos with coding explanations. I make tutorial videos on Technical Topics. Stay Connected, Stay Tuned, Study Smart.
- Knowledge 360 (Akram Sohail)

Only 3.9% of viewers are subscribing to my channel ?.
I request you to please give click on Subscribe button.
It really helps me grow ?.

Please Like, Comment, and Subscribe to my channel. ❤

Follow me on Social Media
--------------------------------------------------
Facebook - https://www.facebook.com/sonu.babu.5872682/
Instagram - https://www.instagram.com/akkubakku007/
WhatsApp - https://wa.me/+919090484904
LinkedIn - https://www.linkedin.com/in/akram-sohail-499489131/
Skype - https://join.skype.com/invite/snliyulHrEBb
Google+ - https://plus.google.com/u/0/116728183002228924227
Blog - https://knowledge360blog.blogspot.in/

Business/Mentorship/Projects - knowledge.360.knowledge@gmail.com
Source Codes -

Topics
---------
Oracle
MySQL
PostgreSQL
SQL Server
PHP
C
C++
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows

Description
------------------

REVOKE CONNECT ON DATABASE dvdrental from public;

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'dvdrental';

drop database dvdrental;

ERROR: database "dvdrental" is being accessed by other users
DETAIL: There is 1 other session using the database.