SQL input consists of a sequence of commands. A command is composed of a sequence of tokens, terminated by a semicolon (

The bytea data type allows storage of binary strings; see Table 8-6. Table 8-6. Binary

Information about text search configuration objects can be obtained in psql using a set of commands:

NameALTER MATERIALIZED VIEW -- change the definition of a materialized view Synopsis

The current limitations of PostgreSQL's text search features are: The

If the primary server fails then the standby server should begin failover procedures. If the standby server fails then no failover need take

NameCREATE POLICY -- define a new row level security policy for a table Synopsis

The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

This section describes functions for operating on sequence objects, also called sequence generators or just sequences. Sequence objects are special

NameCREATE TEXT SEARCH TEMPLATE -- define a new text search template Synopsis