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