How to drop PostgreSQL database through command line [closed]

by

You can run the dropdb command from the command line:

dropdb 'database name'

Note that you have to be a superuser or the database owner to be able to drop it.

You can also check the pg_stat_activity view to see what type of activity is currently taking place against your database, including all idle processes.

SELECT * FROM pg_stat_activity WHERE datname="database name";

Note that from PostgreSQL v13 on, you can disconnect the users automatically with

DROP DATABASE dbname WITH (FORCE);

or

dropdb -f dbname

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. How to import CSV file data into a PostgreSQL table
  4. The forgotten assignment operator “=” and the commonplace “:=”
  5. Equivalent to unpivot() in PostgreSQL
  6. Passing user id to PostgreSQL triggers
  7. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  8. I forgot the password I entered during postgres installation
  9. Do nullable columns occupy additional space in PostgreSQL?
  10. How to configure PostgreSQL to accept all incoming connections
  11. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  12. Disable PostgreSQL foreign key checks for migrations
  13. Prevent recursive trigger in PostgreSQL
  14. serial in postgres is being increased even though I added on conflict do nothing
  15. Can’t connect to Postgresql on port 5432
  16. PostgreSQL Error: Relation already exists
  17. How to make a select with array contains value clause in psql
  18. Using row_to_json() with nested joins
  19. Use variable set by psql meta-command inside of DO block
  20. Sorting array elements
  21. pgAdmin III Why query results are shortened?
  22. How do I handle opening/closing Db connection in a Go app?
  23. How do I alter the date format in Postgres?
  24. OpenShift: How to connect to postgresql from my PC
  25. clojure.java.jdbc lazy query
  26. Alternate output format for psql showing one column per line with column name
  27. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  28. Destroying a Postgres DB on Heroku
  29. Is it possible to change the natural order of columns in Postgres?
  30. ERROR: could not stat file “XX.csv”: Unknown error

Leave a Comment