pgAdmin shortcuts to execute scripts
Select the relevant portion and hit the F5 key in the SQL editor of pgAdmin.
OR use the "Execute query" button (green arrow) in the toolbar.
If nothing is selected, the whole script is executed.
on mac use the fn key (bottom left) + F5