PostgreSQL
Connect to a Postgres database in Arctype.
To begin, select the desired workspace for your new Postgres data source. Then, click the gear icon and select Manage connections
Create a new Workspace in the workspace dropdown.
Once the connections modal appears, click + Add Connection and select PostgreSQL. Then, enter your credentials or paste a connection string in the Connection URL input:
For details on the inputs of each connection, see below. After writing down your values, test your connection and save. You're all done!
If you're using a localhost database, download our desktop app from arctype.com

PostgreSQL Credentials Cheat Sheet

  • Name your connection is primarily for you to keep track of your connections. (optional)
  • Host is the hostname of your database server
  • Port is where it is hosted. The default is 5432
  • User is your username
  • Password is the password for your database
  • For Database, use the name of your database
You can also learn more about different types of Postgres connections by checking out the Arctype resource guides.

Postgres examples

Check out our blog post on how you can use MySQL and Arctype to do some incredible things. This post will teach you more about inspecting joins in Postgres:
Inspecting Joins in PostgreSQL
Arctype Blog
You might also find this blog post about Postgres hooks enlightening.
Hooks: The secret feature powering the Postgres ecosystem
Arctype Blog