DbSchema Database Designer

DbSchema | 10+ Essential PostgreSQL Commands

Publish on DbSchema Blog >>>

The table below contains the essential commands for PostgreSQL. These commands will help you easily manage your PostgreSQL databases.

Function Command Syntax Comments
Connect to a database under a specific user psql -d database -U user -W Replace database and user
Connect to a database on another hots psql -h host -d database -U user -W Replace the host, database and user
Switch connection \c dbname username Replace with the name of the database & the username. If the username is left empty, it will automatically connect with current user
List available databases \l
List available schemas \dn
List available tables \dt To list tables from all schemas, add *.*. To list from a specific schema, add schema_name.*(ex. \dt information_schema.*
Describe a table \d table_name
List available views \dv
List indexes \di
List data types \dT+
List users \du This command will also list the roles of the users
Access command history \s To save the command history to a file, specify the filename after the command
Get help on commands \? This will show a list with all the commands available in PostgreSQL.
Get help on a specific statement \h statement This will show you details about a specific PostgreSQL statement. (ex. \h CREATE TABLE)
Quit \q

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.