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: 
The following will take you to PostgreSQL's interactive terminal:

```
$ psql <your database name>

```

Then enter `\e` (or `\edit`) to open an editor (`vi` is default):

```
# \e

```

Write some query:

```
select now();

```

Finally, save and quit your editor (e.g. `:wq` in `vi`), and `psql` will run the query you just wrote.

To set a different editor, such as `vim` or `nano`, set one of the following environment variables: `PSQL_EDITOR`, `EDITOR`, `VISUAL`.

For more information, see <https://www.postgresql.org/docs/current/app-psql.html> and search for `\e`.
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.