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`.
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 `;`.