Here we give a short overview of the stages a query has to pass in order to obtain a result.

Functions and triggers allow users to insert code into the backend server that other users might execute unintentionally. Hence, both mechanisms permit users to "Trojan

In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is to control the indexing

NameSTART TRANSACTION -- start a transaction block Synopsis

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.

NameVACUUM -- garbage-collect and optionally analyze a database Synopsis

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

This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know.