Using

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.

Sample user scenarios

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.

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.

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.

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

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

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

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.

   

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.

   

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.

   

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.

   

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.

   

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.