Nvim Format Sql
![cover for article Nvim Format Sql](/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fcover.6f7d0624.jpg&w=2048&q=75)
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