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!

On this page