Aibulat/pgsqlv0.0.16

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.16

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