Create and modify SQL queries.

You are logged in to Data Director as a user with appropriate privileges on the database or schema.

1

Click the Manage and Monitor tab.

2

Right-click a database and select Open vPostgres Console.

3

Click Enter SQL.

4

Enter a query in the Entry pane.

You can type or modify a SQL query, test the query, and analyze the query's execution plan before running it.

Type the query in the entry pane.

Click Open to open a SQL script file.

5

Click Execute to run the query.

If the query runs successfully, data appears in the Output pane.