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 wit

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 :).