After DBeaver PRO is connected to an instance of EDB Postgres Advanced Server or EDB Postgres Extended Server, you can access the capabilities of DBeaver PRO.


We refer to EDB Postgres Advanced Server, EDB Postgres Extended Server, and PostgreSQL as the Postgres distribution. The specific distribution type depends on your needs and preferences.

Sample user scenarios


These user scenarios are provided as example use cases of DBeaver PRO and EDB Postgres Advanced Server or EDB Postgres Extended Server. They aren't intended to show all functionality.

Connecting to the database

  1. Launch DBeaver PRO.
  2. Double-click the database connection you want to open.
  3. Enter the username and password, and select OK.

Connecting to the Database

You are now connected to your database instance.

Viewing tables and data

Using the appropriate SQL code, three tables (AGENTS, CUSTOMERS, and ORDERS) were created in the edb database, and data was inserted to help visualize some basic functionality.

Database Navigator for Viewing Tables and Data

  1. In the Database Navigator, right-click your database. In this example that's edb.
  2. Select SQL Editor > Open SQL Console. This opens a console where you can enter and run SQL code.

Opening the SQL Console

  1. After the tables are created, double-click the table name to look at the properties. The figure shows the properties of the Customers table.

Table Properties

  1. Select the Data tab to view the data in the table.

Viewing the Table's Data

  1. Select the ER Diagram tab to view the Entity Relationships for the table.

Viewing the Entity Relationships

Using schema compare

DBeaver introduced the schema compare feature that allows you to compare schemas, databases, or tables. You can compare two schema/database structures and generate a report.

See the DBeaver documentation for more details on how to enable the full functionality of this feature, along with its requirements.

  1. In the database navigator, right-click the schema, database, or table you want to compare.

    Compare/Migrate Schema

  2. From the context menu, select Compare/Migrate > Compare/Migrate Schema.

    When the Schema Compare window opens, the source schema/database/table you selected in the first step is selected.

  3. In the list of targets, expand the tree and select the database for your target.

    Select Target Source for Schema Compare

  4. Expand the target sources until you get to the item you want to compare. In this example, the EnterpriseDB schema is selected for the source, and the public schema is selected for the target.

    Source and Target Schemas to Compare

  5. Select Next.

  6. On the Schema Compare Settings page, make sure all of the objects that you want to compare are selected. You can also select the type of report engine for your needs.

    Schema Compare Settings

  7. Select Proceed.

  8. The Results window is generated, where you can compare your data and save a report. In this example, the schemas were the same so the results don't show any difference.

    Schema Comparison Results for the Same Schema

You usually compare schemas that aren't the same. The following image shows what the report can look like when comparing different schemas in a database.

Schema Comparison Results for Different Schemas

Could this page be better? Report a problem or suggest an addition!