- Navigate to the Hydra Dashboard.
- Select your project.
- Select SQL Editor.
- Enter a query into the editor and click the green triangle to execute and view the results.
Running a query
Run each statement by clicking the green triangle next to each query..png)
When querying objects such as tables and columns with upper case letters in their name, remember to enclose the identifier name in quotes. For example:
SELECT * FROM "Company"
. Postgres changes identifier names to lower case unless they are quoted. The same applies when creating objects in Postgres. For example, CREATE TABLE DEPARTMENT(id INT)
creates a table named department
in Postgres. For more information about how quoted and unquoted identifiers are treated by Postgres, see Identifiers and Key Words in the PostgreSQL documentation.Save Queries
The SQL Editor allows you to save your queries. To save a query:- Enter the query into the editor.
- Enter a name for the query at the top of the page.
- Click Save Query to save the query.