pgsql 0.0.14

Install Dotnet SDK on Ubuntu

# 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

Install Dotnet SDK on Macos

# Macos
brew install --cask dotnet-sdk

# Check:
dotnet --version

Install

dotnet tool install --global pgsql

Update

dotnet tool update --global pgsql --version 0.0.14

Set Env vars

export DB_URL="pg://localhost:5432/postgres"
export DB_USER="postgres"
export DB_PASS="P@ssw0rd"

Start interactively

pgsql

Use interactively

> select * from someschema.sometable;

> \help

> \schema someschema

> select * from sometable;

> \output file.json

> select * from sometable;

> \output file.msgpack

> select * from sometable;

> \q

Use in batch mode

pgsql file.sql