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: 
There is really no such thing as a "multi-line query" - as far as PostgreSQL cares, all that whitespace and those newlines are meaningless (unless they occur inside a string or we're talking about tabs & such in a `COPY` statement or a few other special places).

Writing queries "on the console" over SSH is usually done with the `psql` tool, which is the Postgres interactive terminal (see the [docs](https://www.postgresql.org/docs/current/app-psql.html) for more info).

You can pass *text files containing queries* to `psql` using the `-f` option.

You can also pass queries to `psql` on the command line (quoted as appropriate for your shell), or pipe them in via STDIN (the standard input stream) - see the `-c` option.
You can write the query to a temp file and execute it with `psql -f /path/to/temp/file`