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: "PostgreSQL provides the CREATE EXTENSION command to load extensions to the current database."

A block of code is set as follows:

log_destination = 'csvlog'
logging_collector = on
log_filename = 'postgresql.log'
log_statement = 'all'

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

postgres=# CREATE FOREIGN TABLE postgres_log
( log_time timestamp(3) with time zone,
  user_name text,
  database_name text,

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

sudo service postgresql restart

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: "Select System info from the Administration panel."