NameANALYZE -- collect statistics about a database Synopsis
NameCREATE RULE -- define a new rewrite rule Synopsis
NameALTER LARGE OBJECT -- change the definition of a large object Synopsis
PostgreSQL enforces SQL uniqueness constraints using unique indexes, which are indexes that disallow multiple entries
NameINSERT -- create new rows in a table Synopsis
NameTRUNCATE -- empty a table or set of tables Synopsis
NameLISTEN -- listen for a notification Synopsis
The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte
The task of the planner/optimizer is to create an optimal execution plan. A given SQL query (and hence, a query tree) can be actually executed in a
It is possible to use SSH to encrypt the network connection between clients and a PostgreSQL server. Done
Page 23 of 60