This was a good post from a few years ago on HN with tips on working with PostgreSQL via the command line (and your favorite text editor): https://news.ycombinator.com/item?id=5214072