Run SQL in Vim
When I run <Leader>r
from a .sql
file in Vim,
the file's contents are run against my Postgres database through psql
and the output is printed to my screen.
The configuration for this is in ~/.vim/ftplugin/sql.vim
:
" Run current file
nmap <buffer> <Leader>r :redraw!<CR>:!psql -d $(cat .db) -f %<CR>
I also have a .db
file that contains only the local database name:
example_development
See man psql
for more detail on the -d
and -f
flags.