Database, Schema, and Table Editors

dbForge Studio for PostgreSQL provides visual editors that let you work with databases, schemas, and tables:

  • Database Editor
  • Schema Editor
  • Table Editor

Each editor features an intuitive interface, flexible layouts, and built-in actions for refreshing objects, applying changes, or scripting modifications. This makes them convenient and efficient tools for database, schema, and table design and maintenance.

Database Editor

Database Editor lets you create and modify a database without writing SQL manually. After you define database details in the editor, a corresponding CREATE DATABASE or ALTER DATABASE statement is generated automatically.

On the Main tab, you can configure database properties that define the database structure, behavior, and basic settings. The Options tab allows you to set PostgreSQL parameters, while the SQL tab lets you preview the generated SQL script.

To open Database Editor, right-click the required database or server connection in Database Explorer and select New Database or Edit Database. Alternatively, open the editor from the Database menu on the top menu bar or from the Database Design section on the Start Page.

Schema Editor

Schema Editor provides a visual interface for creating and managing database schemas. It automatically generates the corresponding CREATE SCHEMA or ALTER SCHEMA script, so you don't need to write DDL statements manually.

On the Main tab, you can define schema properties, such as name, owner, and comment. The SQL tab allows you to review and format the generated SQL script before you apply it.

To open Schema Editor, right-click an existing schema in Database Explorer and select New Schema or Edit Schema. You can also create a new schema using the database shortcut menu.

Table Editor

Table Editor enables you to create and manage database tables through a graphical interface. You can use the editor to define and modify table columns, constraints, indexes, and triggers without writing DDL statements manually. The editor generates the corresponding CREATE TABLE or ALTER TABLE statement based on your changes.

The editor is organized into several tabs:

  • The General tab lets you create and manage columns and their properties.
  • The Constraints tab provides access to primary, foreign, and unique keys, as well as check constraints.
  • The Indexes tab allows you to create and configure indexes.
  • The Triggers tab lets you manage triggers defined on the table.
  • The Data tab lets you view and edit table data.
  • The SQL tab displays the generated DDL script, which you can review before applying changes.

To open Table Editor, right-click a table or the Tables node in Database Explorer and select New Table or Open Editor. You can also create a new table from the standard toolbar, the Database menu on the top menu bar, a database shortcut menu in Database Explorer, or the Database Design section on the Start Page.

Get your free trial of dbForge Studio for PostgreSQL to explore how convenient visual object editors help you configure all required settings through an intuitive interface.

Go to Data Editor

Go to Database Explorer