Follow this step-by-step guide to install PostgreSQL ... To execute SQL commands and queries, add a semicolon (;) when the query is complete and then press . Here we create a new database ...