Skip to content

Instantly share code, notes, and snippets.

@khaliqgant
Last active August 3, 2022 20:21
Show Gist options
  • Save khaliqgant/fbb7d6f9932bf5157d9641384c81cf5e to your computer and use it in GitHub Desktop.
Save khaliqgant/fbb7d6f9932bf5157d9641384c81cf5e to your computer and use it in GitHub Desktop.
[Postgres Drop Database] Drop live database and create public schema #postgres #database
# with auth
> psql -h 10.000.0.0 -d mydb -U myuser
> psql postgres postgres
drop schema public cascade;
create schema public;
\q and enter to exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment