Package Description
$ dotnet add package pgsql
# setup apt repo:
wget https://packages.microsoft.com/config/ubuntu/22.04/packages-microsoft-prod.deb -O packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
sudo apt-get update
# actual install:
sudo apt-get install -y dotnet-sdk-7.0
# Check:
dotnet --info
# Macos
brew install --cask dotnet-sdk
# Check:
dotnet --version
dotnet tool install --global pgsql
dotnet tool update --global pgsql --version 0.0.12
export DB_URL="pg://localhost:5432/postgres"
export DB_USER="postgres"
export DB_PASS="P@ssw0rd"
pgsql
> select * from someschema.sometable;
> \help
> \schema someschema
> select * from sometable;
> \q