This guide will walk you through the steps to connect to Nile using PSQL.
  1. Create a Nile’s Postgres database through the UI or use one of your existing databases to follow along.
PSQL-1
  1. Once you are inside a specific database, click on the settings tab on the left and navigate to the connections screen
PSQL-2
  1. Click on the Postgres icon to get the connection string
PSQL-3
  1. Click “Generate credentials”. Use this if you really want to simplify the access. If not, you can replace the username and password manually and use that through commandline.
PSQL-4
  1. Copy the connection string and run it on the command line.
PSQL-5
  1. You can now use the full power of psql with Nile. You can take a look at all the tables and schemas using \dt
PSQL-6
  1. Execute any queries to interact with the tables. For example, if you want to see the rows in tenants table, execute a select query on it
PSQL-7
  1. Have fun using PSQL!