Skip to content

Instantly share code, notes, and snippets.

@mortalis13
Created October 1, 2024 09:05
Show Gist options
  • Save mortalis13/adb7fb79acde3cd4cae4b870f606dc8c to your computer and use it in GitHub Desktop.
Save mortalis13/adb7fb79acde3cd4cae4b870f606dc8c to your computer and use it in GitHub Desktop.
Minimal psql setup

To only have the working psql tool to read/edit an existing database: Windows OS

  1. Download the PostgreSQL binaries package: https://www.enterprisedb.com/download-postgresql-binaries
  2. Unpack the files from bin:
    psql.exe
    libcrypto-3-x64.dll
    libiconv-2.dll
    libintl-9.dll
    libpq.dll
    libssl-3-x64.dll
    libwinpthread-1.dll
    
  3. Execute psql from the folder

The binary itself should run without global PATH, but to execute commands it seems to need the more command from system32 Windows folder, so the default system PATH is preferrable.

@dcogny
Copy link

dcogny commented Dec 23, 2024

Thank you, this is the smallest (while still usable) build I found to run psq.exe without installing it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment