So far we have explained how to add data to tables and how to change data. What remains is to discuss how to remove data that is no longer needed. Just as adding data is only

NameDROP ROLE -- remove a database role Synopsis

NameLOCK -- lock a table Synopsis

NameINSERT -- create new rows in a table Synopsis

This section describes additional functions and operators that are useful in connection with text search. 12

To retrieve data from a table, the table is queried. An SQL SELECT statement is used

NameANALYZE -- collect statistics about a database Synopsis

Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical conventions (e.g., date/time types)

An alternative to the built-in standby mode described in the previous sections is to use a restore_command that polls the archive location. This

Namepg_test_fsync -- determine fastest wal_sync_method for PostgreSQL