The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server
Namepg_dump -- extract a PostgreSQL database into a script file or other archive file
NameCREATE DATABASE -- create a new database Synopsis
NameSET ROLE -- set the current user identifier of the current session Synopsis
Namedropuser -- remove a PostgreSQL user account
You can update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by 2 degrees after November 28
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
NameLOCK -- lock a table Synopsis
This section describes additional functions and operators that are useful in connection with text search. 12
NameSELECT, TABLE, WITH -- retrieve rows from a table or view Synopsis
Page 14 of 60