Signup to the waiting list!
You can perform this task in 2 ways.
One is using
Type the command
\l), and PostgreSQL will show you the list of databases (and templates):
In this case, the databases list is
template1 are templates.
Templates are templates for new databases, and you can use them to pre-populate new databases using the syntax
CREATE DATABASE databasename TEMPLATE template0.
By default, the template used when creating a new database using
CREATE DATABASE databasename is
It’s a topic that does not matter now, but I just want you to know what templates are.
A more advanced view, which includes the disk size of each single database, can be retrieved using
The other way to list databases is by using a SQL query.
SELECT datname FROM pg_database WHERE datistemplate = false;
This will list databases, excluding templates:
More database tutorials:
- The MongoDB basics tutorial
- How MongoDB is different from a SQL database
- Information systems, data and information
- Data models
- Introduction to the ER Data Model
- The Relational Model
- Relational Algebra
- Relational Databases
- What is a Database? And a DBMS?
- Introduction to SQL
- How to install PostgreSQL on macOS
- Do you always need a database for your app?
- How to install SQLite on macOS
- Introduction to PostgreSQL
- PostgreSQL User Permissions
- How to list all users in PostgreSQL
- How to switch database using PostgreSQL
- How to list all databases using PostgreSQL
- How to list tables in the current database using PostgreSQL
- How to install MySQL on macOS
- Creating a user on MySQL
- PostgreSQL vs MySQL, a comparison
- SQLite User Permissions
- MySQL User Permissions
- SQL, creating a table
- SQL, adding data to a table
- SQL, how to use SELECT
- SQL, Handling empty cells
- SQL, Unique and Primary keys
- SQL, how to update data
- SQL, how to update a table structure
- SQL, how to delete data and tables
- SQL Joins
- SQL Views
- How to insert multiple items at once in a MongoDB collection
- How to remove all items from a MongoDB collection