DbSchema Database Designer

DbSchema | 3 ways to List All Schemas from PostgreSQL



1.Using SQL Syntax

There are two ways in which you can use the SQL Synthax to list all schemas from PostgreSQL.

Using the (ANSI) standard INFORMATION_SCHEMA:

 SELECT schema_name
 FROM information_schema.schemata;

Another option is

 SELECT nspname
 FROM pg_catalog.pg_namespace;

2.Using psql

In psql all schemas can be listed by executing the next command:

 /dn

You can find a cheat sheet of the important commands in psql here

3.Using DbSchema

DbSchema is a PostgreSQL client and visual designer. DbSchema can be downloaded for free. No registration is required.

In DbSchema you don’t have to run any query to see the full list of your PostgreSQL database. The tables are shown in the left menu. From there, you can drag them to the layout to edit or browse.

dbschema show tables

DbSchema includes further features, which allows to:

  • Design the schema in team and deploy the schema on multiple databases
  • Export HTML5 database documentation
  • Visually explore the database data
  • Build queries using the mouse
  • Query editor
  • Random data generator
  • Data loader

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.