I'm trying to drop my database and create a new one through the command line. I log in using psql -U username and then do a \\connect template1, followed by a DROP DATABASE databasename;. I get …

Apr 8, 2016 · Because, you are trying to execute dropDb command on database, to which you have open connection. According to postgres documentation: You cannot be connected to the database …

Sep 27, 2023 · Works for me. 1) Are you sure you are connected to a Postgres 13+ database? What does select version() return? 2) What psql version are you using? 3) Did you copy/paste this query …

Nov 16, 2012 · The sudo -u postgres psql connects to postgres database. You need to specify database: sudo -u postgres psql mydbname and then you can use metdata commands like \d, \dt, …

Mar 23, 2011 · 871 I need to write a script that will drop a PostgreSQL database. There may be a lot of connections to it, but the script should ignore that. The standard DROP DATABASE db_name query …

Jul 10, 2018 · DROP USER (or DROP ROLE, same thing) cannot proceed while the role still owns anything or has any granted privileges on other objects. Get rid of all privileges with DROP OWNED …

How can I drop all tables in PostgreSQL, working from the command line? I don't want to drop the database itself, just all tables and all the data in them.

Jan 28, 2012 · PostgreSQL: Drop Database but DB is still there [duplicate] Asked 14 years, 2 months ago Modified 5 years, 6 months ago Viewed 35k times

107 Update in Postgresql 13 You could just use this command to drop a Database forcefully, thus disconnecting each user/app connected to it. ... You could check the manual for more. FORCE - …

Jan 13, 2010 · To drop and recreate tables, you could use the --clean command-line option for pg_dump to emit SQL commands to clean (drop) database objects prior to (the commands for) creating them.