Connect to your database in pgAdmin
pgAdmin is a free database management tool compatible with Reason Automation. It has many functions but we recommend using it as a SQL workbench: a way to quickly prototype and iterate on custom SQL queries.
Download and install pgAdmin
Download and install pgAdmin for your operating system HERE.
Connect your database to pgAdmin
1) Open pgAdmin and click "Add New Server" to set up your connection to Reason
2) Name the connection whatever you want, e.g. "Reason Automation" or "Amazon data pipeline."
3) Click into the Connection tab, then fill in your connection details.
- Host name/address
- Port
- Maintenance database
- Username
- Password
4) That's it! Click Save and your connection is set.
How to write SQL in pgAdmin
1) Open pgAdmin and connect to the server you previously set up.
2) Right click your database and choose "Query tool" from the menu.
3) You can write SQL in this window.
- Click the play button to run your query
- Use the "Explain and analyze" button to analyze your query's performance and see whether it will run as expected
More references & resources
- Guided postgreSQL tutorials - helpful guides on everything from querying single tables, to complex joins and subqueries.
- Official pgAdmin documentation - technical documentation suitable for developers and BI experts
- Functions & operators - the most important part of the official documentation for writing queries!