NameVALUES -- compute a set of rows Synopsis
NameNOTIFY -- generate a notification Synopsis
NameCREATE FOREIGN DATA WRAPPER -- define a new foreign-data wrapper Synopsis
NameIMPORT FOREIGN SCHEMA -- import table definitions from a foreign server Synopsis
NameEXPLAIN -- show the execution plan of a statement Synopsis
For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 19-2. Some of these options exist for historical
WITH provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as Common Table Expressions
NameALTER LANGUAGE -- change the definition of a procedural language Synopsis
PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to
The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time
Page 54 of 60