To get the most out of this book

This book has been written for a broad audience. In order to follow the examples presented in this book, it makes sense to have at least some experience with SQL and, perhaps, even PostgreSQL in general (although, this is not a mandatory requirement). In general, it is a good idea to have some familiarity with the Unix command line as well.

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: "Mind that the order in the ENUM type does matter."

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

test=# CREATE TYPE currency AS ENUM ('USD', 'EUR', 'GBP');
CREATE TYPE

Bold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "This configuration allows you to authenticate using lightweight directory access protocol (LDAP)."

Warnings or important notes appear like this.

Tips and tricks appear like this.