Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "To figure out what is going wrong, PostgreSQL offers the EXPLAIN command."

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

test=# EXPLAIN SELECT * FROM t_test ORDER BY id DESC LIMIT 10; 
Warnings or important notes appear like this.
Tips and tricks appear like this.

Get Mastering PostgreSQL 10 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.