Awesome

pgscope

PL/pgSQL source code tree search and browse tool

Embed seamlessly with vim

Getting Started

Download

Installation from source

git clone https://github.com/gjalves/pgscope.git
cd pgscope
git clone https://github.com/lfittl/libpg_query.git
cd libpg_query
make
cd -
make
cp pgscope /usr/bin/pgscope
mkdir -p ~/.vim/after/ftplugin/
cp sql.vim ~/.vim/after/ftplugin/sql.vim

Using

Type pgscope to index all .sql files in current and descending directories. After that, open your .sql file with vim and put cursor under any external function. Call it using <kbd>CTRL</kbd>+<kbd>]</kbd>. If you wish to came back to calling function, use <kbd>CTRL</kbd>+<kbd>o</kbd>

You can autocomplete functions using <kbd>CTRL</kbd>+<kbd>x</kbd> and <kbd>CTRL</kbd>+<kbd>o</kbd> If you need to reindex, use :!pgscope in vim.

If you wish to reindex automatically after save, type in vim command mode:

:autocmd BufWritePost *.sql :silent !pgscope

Donation

Contributions of any amount are very welcome and will help the continuity of this software development

Author

Gustavo Junior Alves