Create and modify SQL queries.

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


Click the Manage and Monitor tab.


Right-click a database and select Open vPostgres Console.


Click Enter SQL.


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.


Click Execute to run the query.

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