- Install and Connect to PostgreSQL 10 on Ubuntu 16.04
- Creating and Deleting a PostgreSQL Database
- Listing and Switching Databases in PostgreSQL
PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
Log into your Ubuntu 16.04 server
Step 1: Login to your Database
su - postgres
Step 2: Enter the PostgreSQL environment
With the psql command, you’ll be greeted by its current version and command prompt.
Type "help" for help.
Step 3: List Your PostgreSQL databases
Often, you’ll need to switch from database to database, but first, we will list the available database in PostgreSQL
By default, PosgreSQL has 3 databases: postgres, template0 and template1
Step 4: Switching Between Databases in PostgreSQL
Switching between databases is another way of saying you are closing one connection and opening another. When you need to change between databases, you’ll use the “connect” command, which is conveniently shortened to \c, followed by the database name.