Conventions used

There are several text conventions used throughout this book.

Code in text: Indicates code words in the text, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “To explore the mining areas in Brazil, we can use the ST_Area function.”

A block of code is set as follows:

SELECT row_number() over () AS _uid_,* FROM (SELECT * FROM getprotecteda('10160475')
) AS _subq_1_

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold: “The synopsis of ST_Within includes the following:”

boolean ST_Within(geometry A, geometry B);

Any command-line input or output is written as follows:

Query returned successfully in 129 msec

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “In pgAdmin, we can observe these results in Geometry Viewer.”

Tips or important notes

Appear like this.