Nvim Format Sql

I was looking for a way to format my sql in nvim directly.
I found a nice cli called pgFormatter
On mac you can install it with brew
brew install pgformatter
In my case I use a linux distrib based on ubuntu
sudo apt-get install libcgi-pm-perl
cd /tmp
export version=5.4
wget https://github.com/darold/pgFormatter/archive/refs/tags/v${version}.tar.gz
tar xzf v${version}.tar.gz
cd pgFormatter-${version}/
perl Makefile.PL
make && sudo make install
After that you can use a range and called the external cli pg_format
with !
# called pg_format on the current line
:.!pg_format
# called pg_format on the visually select lines
:'<,'>!pg_format
#:{range}!pg_format
In action
Read other tils