pgAdmin 4 has a few useful things I should remember:
Query History is really neat. Second tab in the Query Editor page, shows a history of all the queries made and the outcome messages. Easy to find what you have already done.
Ctrl Space triggers code completion. Not quite as good as an IDE but helpful none the less
Keep you columns lower case and you wont have to use quotes for your tables in table queries.