These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5). Servers will be either a Master or a Standby

The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the

This feature was designed to allow parameters not normally known to PostgreSQL to be added by add-on modules (such as procedural languages)

NameDROP FOREIGN TABLE -- remove a foreign table Synopsis

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

As with any server daemon that is accessible to the outside world, it is advisable to run PostgreSQL under a separate user account. This user

Value expressions are used in a variety of contexts, such as in the target list of the SELECT command, as new column values in

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL

SQL is a strongly typed language. That is, every data item has an associated data type which determines its behavior and allowed usage.