‘Using Toad Edge’

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

Sample User Scenarios

Note

This section is provided as an example of Toad Edge and EDB Postgres Advanced Server or EDB Postgres Extended Server. It is not intended to show all functionality.

Connecting to the Database

  1. Launch Toad Edge.

  2. Right click the database connection you want to open and select Connect . You can also select the Connect button and select your database.

  1. Enter the username and password and click OK .

  2. 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. When you connect to the database, a SQL Editor area is open for your database. In this example that is edb . If it isn’t open, you can click on the SQL Editor button at the top to open a new one.

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

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

  1. Click on the Script tab to see the SQL code for the table.