You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This plugin enhances your Oh My Zsh setup by providing an easy way to manage and connect to PostgreSQL databases using pgcli and fzf for a seamless command-line experience.
This plugin enhances your Oh My Zsh setup by providing an easy way to manage and connect to PostgreSQL databases using pgcli and fzf for a seamless command-line experience.
Requirements
Ensure you have the following tools installed before using this plugin:
Add pgconnect to the list of plugins in your .zshrc file:
plugins=(... pgconnect)
Reload your Zsh configuration:
source~/.zshrc
Usage
To manage your PostgreSQL connections, configure your ~/.pg_service.conf file. This file allows you to define multiple database connections. Here is an example configuration:
After setting up your ~/.pg_service.conf, you will be able to see and select these databases from a list using the plugin.
Security Note
To keep your passwords secure, you can use the .pgpass file, which stores your credentials safely. If you prefer, you can also include the password directly in the ~/.pg_service.conf file using the password attribute, though this is not recommended for security reasons.
Feel free to contribute to this project by submitting issues or pull requests. Enjoy seamless PostgreSQL connections with Oh My Zsh!
About
This plugin enhances your Oh My Zsh setup by providing an easy way to manage and connect to PostgreSQL databases using pgcli and fzf for a seamless command-line experience.