PostgreSQL Database Explorer

Managing Database Connections

dbForge Studio for PostgreSQL offers a quick and simple way to manage database connections through Database Explorer, which allows adding, editing, deleting, renaming, or duplicating existing database connections in just a few clicks. Postgres Database Explorer is designed to simplify the work with a bunch of database connections. You can call the Database Connection Properties window right from its upper
pane. You can also close a connection with a single click.

Postgres Database Explorer - Managing Database Connections

Viewing Database Schema Information

You can instantly check database schema information for tables, views, procedures, functions, triggers, and events right from Database Explorer. Just right-click the object you are interested in and select Properties from the context menu that appears.

Postgres Explorer feature - Viewing Database Schema Information

Displaying the Number of Database Objects

For users convenience, Data Explorer built into dbForge Studio for PostgreSQL displays the number of existing database objects. The number of database objects is displayed in parentheses to the right of the folder name.

Postgres Explorer option - Displaying the Number of Database Objects

Filtering Database Objects

The Filtering feature presented in dbForge Studio for PostgreSQL is bound to mitigate navigation through databases that contain a large number of objects. You can use filters to reduce the number of objects displayed in the Postgres Database Explorer tree and work only with the objects you need. To apply filters, right-click the folder with objects and select the Filter option from the context menu that appears.

Postgres Database Explorer feature - Filtering Database Objects

Generating DDL Statements for Database Objects

dbForge Studio for PostgreSQL allows generating DDL statements for tables, views, stored procedures, functions, and triggers. Using the feature, you can generate scripts to recreate the necessary database objects when and where required. In the Postgres Explorer, right-click the object you want to create a DDL statement for, and select the Generate Script As command from the context menu that appears.

PostgreSQL Database Explorer - Generating DDL Statements for Database Objects