How to switch database using PostgreSQL
A quick explanation of how to switch between databases inside the `psql` tool in PostgreSQL
TypeScript Masterclass
Join the waiting list!
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:
- JavaScript Handbook
- TypeScript Handbook
- CSS Handbook
- Node.js Handbook
- Astro Handbook
- HTML Handbook
- Next.js Pages Router Handbook
- Alpine.js Handbook
- HTMX Handbook
- React Handbook
- SQL Handbook
- Git Cheat Sheet
- Laravel Handbook
- Express Handbook
- Swift Handbook
- Go Handbook
- PHP Handbook
- Python Handbook
- Linux/Mac CLI Commands Handbook
- C Handbook