Interface to quickly run a psql command from your ~/.pgpass file
Fetch the latest release for your platform from the following page.
Connections are handled by a ~/.pgpass file as described by the Postgres docs. Each entry should be in the following format:
# NAME=<your connection name>
hostname:port:database:username:password
The commented line with NAME= is optional but will give you an extra descriptor about the database in psqlconnect. An example pgpass file is included. Make sure that your ~/.pgpass has permissions of 0600.
The .pgpass file stores all information in plain text including usernames and passwords. Arguably this isn't a huge deal because if someone has access to your computer you're compromised but if you need an encrypted file/database you won't get it from this solution.
| Keybind | Description |
|---|---|
| j | move the cursor down a line |
| k | move the cursor up a line |
| Enter | run psql with the selected connection |
| f | add/remove a filter |
| r | refresh connections from ~/.pgpass |
| Ctrl+c | quit |
MIT