Question: Say I need hand write some queries in the console, what's the most efficient way of executing multiline queries like `CREATE TABLE` statements?

I am used to using Microsoft Management Studio, but I now find myself having to learn about PostgreSQL on the fly.

Answer: 
Obvious, but if anyone is not aware, you can write multi-line statements directly in the psql prompt:

```sh
psql -h localhost -p 5432 -U postgres public
public=# SELECT
public=# *
public=# FROM
public=# mytable
public=# LIMIT 1;

```

Note the trailing `;` character - any SQL command will only be executed once this character has been issued. So the easiest way is to simply copy & paste multi-line SQL commands with a trailing `;`.
You can write the query to a temp file and execute it with `psql -f /path/to/temp/file`