PostgreSQL interactive terminal
psql (opens in a new tab) is a standard terminal-based front-end to PostgreSQL. Which you can use it to interact with Kubling.
Please note that psql
uses the PostgreSQL protocol, therefore you cannot establish a connection using the Kubling native protocol.
Installation
Ubuntu 23.10,22.04 and Debian 12
sudo apt update
sudo apt install postgresql-client
MacOS Using Homebrew
You will need the Brew Package Manager (opens in a new tab) installed on your system.
One done, open a terminal and just execute:
brew update
brew install libpq
Optionally, symlink
psql
and other libpq
tools and binaries, into /usr/local/bin
:
brew link --force libpq
Windows
In windows, we do recommend installing using the postgresql installer (opens in a new tab).
Usage
Open a terminal and run:
psql -h <IP/HOSTNAME> -p 35432 -U <USERNAME> -W -d <VDB>