ALTER ROLE changes the attributes of a PostgreSQL role. The first variant of this command listed in the synopsis can change many of the role attributes that can be specified in CREATE ROLE. (All the ...

39.1. Overview of Event Trigger Behavior Home 39.3. Writing Event Trigger Functions in C ...

are that the materialized view cannot subsequently be directly updated and that the query used to create the materialized view is stored in exactly the same way that a view's query is stored, so that ...

pg_waldump displays the write-ahead log (WAL) and is mainly useful for debugging or educational purposes. This utility can only be run by the user who installed the server, because it requires ...

CREATE RULE defines a new rule applying to a specified table or view. CREATE OR REPLACE RULE will either create a new rule, or replace an existing rule of the same name for the same table. The name of ...

ALTER SEQUENCE changes the parameters of an existing sequence generator. Any parameters not specifically set in the ALTER SEQUENCE command retain their prior settings. Changing the data type ...

For best optimization results, you should label your functions with the strictest volatility category that is valid for them. Another important example is that the current_timestamp family of ...

DROP TRIGGER removes an existing trigger definition. To execute this command, the current user must be the owner of the table for which the trigger is defined. Destroy the trigger if_dist_exists on ...

Do not throw an error if the view does not exist. A notice is issued in this case. Automatically drop objects that depend on the view (such as other views), and in ...