Re:Psql command line tutorial and cheat sheet
by jasonl99 on Monday November 16, 2020 @08:21PM
(#25119294)
One thing I've found useful when listing tables that you can't exactly remember the name, you can use wildcards.
\dt cust*
will list all tables that start with "cust". It works with other commands as well (like \l).
Also, I like to split my terminal using tmux, and have a neovim editor in one pane, psql in the other. I just keep doing "\i file_name.sql" as I perfect the query.
I definitely agree wholeheartedly about pspg. They even have a FoxPro theme, which has a special place in my heart :).
\dt cust*
will list all tables that start with "cust". It works with other commands as well (like \l).
Also, I like to split my terminal using tmux, and have a neovim editor in one pane, psql in the other. I just keep doing "\i file_name.sql" as I perfect the query.
I definitely agree wholeheartedly about pspg. They even have a FoxPro theme, which has a special place in my heart :).