pgsql 0.0.13

.NET 7.0 This package targets .NET 7.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet tool install --global pgsql --version 0.0.13
This package contains a .NET tool you can call from the shell/command line. 
dotnet new tool-manifest
                    


                            if you are setting up this repo
                        

                    

                
dotnet tool install --local pgsql --version 0.0.13
This package contains a .NET tool you can call from the shell/command line. 
#tool dotnet:?package=pgsql&version=0.0.13
                    


                    

                
nuke :add-package pgsql --version 0.0.13

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

Set Env vars

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

Use

#pgsql

> select * from someschema.sometable;

> \help

> \schema someschema

> select * from sometable;

> \output file.json

> select * from sometable;

> \q

#cat file.json
Product Compatible and additional computed target framework versions.
.NET net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last Updated
0.0.17 1,565 6/22/2023
0.0.16 394 5/30/2023
0.0.15 348 5/29/2023
0.0.14 274 5/29/2023
0.0.13 293 5/28/2023
0.0.12 323 5/27/2023
0.0.11 308 5/27/2023
0.0.10 323 5/26/2023
0.0.9 357 5/26/2023
0.0.8 330 5/25/2023
0.0.7 320 5/25/2023
0.0.6 316 5/24/2023
0.0.5 281 5/24/2023
0.0.4 265 5/24/2023
0.0.3 285 5/24/2023
0.0.2 305 5/24/2023
0.0.1 373 5/24/2023