The first example: I'd like to see Hunter's Valley in the execute line as escaping isn't mentioned on the page or its links. Just a suggestion to help us beginners understand how things work.
This is one of hundreds of documentation examples that include literals. Why is this one special that it needs to provide an example of a literal containing a single quote that requires escaping?
The SQL Command section of the docs properly presumes the reader has significant familiarity with writing SQL queries in PostgreSQL and is looking either for understanding what the different kinds of commands are or, more commonly, needs a refresher as to the exact syntax for less often used commands.
More precisely, the vast majority of the docs assume you've read "Chapter 4. SQL Syntax".
