Using DBeaver PRO

Suggest edits

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

Sample User Scenarios

Note

The user scenarios shown are provided as example use cases of DBeaver PRO and EDB Postgres Advanced Server or EDB Postgres Extended Server. They are not 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 click OK.

DBNavigate

  1. 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.

DBNavigate2

  1. In the Database Navigator, right click on your database. In this example that is edb.
  2. Select SQL Editor -> Open SQL Console. This will open the <edb>Console to allow you to enter and run SQL code.

DBNavigate3

  1. Once the tables have been created, double click on the table name to look at the properties. In this case we selected the Customers table.

Console

  1. Click on the Data tab to view the data in the table.

Console2

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

Console3


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