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.

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.

Displaying the Number of Database Objects

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

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 display fewer objects 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.

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.