How to install postgresql-client / psql on Nixos

user_1293385 0
Viewed 1279

I'm wondering how to install the psql command on NixOS. To be clear: I'm only interested in the client, not the server.

I've looked at the derivation but couldn't find any pointers.

Is there a way to create a derivation without building from source?

Thanks!

nix-shell nixos nix psql postgresql
2 Answers

The psql command is in any of the postgresql* packages, so you can just add that to environment.systemPackages and rebuild:

environment.systemPackages = [ pkgs.postgresql ];
user_66057420

Instead of installing the package you can also use nix shell / run, and define a shell alias:

alias psql="nix shell nixpkgs#postgresql --command psql"
user_8553660
Related