How to switch database using PostgreSQL
A quick explanation of how to switch between databases inside the `psql` tool in PostgreSQL
THE AHA STACK MASTERCLASS
Launching May 27th
Inside psql, you always have one active database, where you are “into”. By default it’s the one you connect to in the first place. When you run:
psql postgresyou’ll connect to the postgres database.
To switch database, use the \connect command, or \c:
PostgreSQL will close the connection to the previous database you were connected to, and will connect to the new one you specified.
I wrote 20 books to help you become a better developer:
- Astro Handbook
- HTML Handbook
- Next.js Pages Router Handbook
- Alpine.js Handbook
- HTMX Handbook
- TypeScript Handbook
- React Handbook
- SQL Handbook
- Git Cheat Sheet
- Laravel Handbook
- Express Handbook
- Swift Handbook
- Go Handbook
- PHP Handbook
- Python Handbook
- Linux Commands Handbook
- C Handbook
- JavaScript Handbook
- CSS Handbook
- Node.js Handbook