List, Add, Drop Database List databases postgres=# \d Add database postgres=# createdb testdb or postgres=# create database testdb with owner facar; Drop database postgres=# dropdb testdb List, Add, Drop, Grant User and Schema List Users postgres=# select * from pg_user; Add User postgres=# create user facar with encrypted password ‘password’; or postgres=# createuser (interactive user create)…
Month: June 2016
ERROR: database “database_name” is being accessed by other users in PostgreSQL
Error When you execute drop database command, database get an error like ERROR: database “database_name” is being accessed by other users.> Solution