PostgreSQL Database

  1. Procedural Programming and Functions
    1. Introduction to PL/pgSQL
      1. Enabling PL/pgSQL
        1. Structure of PL/pgSQL Blocks
          1. Variables and Data Types
            1. Control Structures
              1. IF Statements
                1. CASE Statements
                  1. LOOP Statements
                    1. WHILE Loops
                      1. FOR Loops
                      2. Exception Handling
                      3. User-Defined Functions
                        1. Creating Functions
                          1. Function Parameters
                            1. IN Parameters
                              1. OUT Parameters
                                1. INOUT Parameters
                                  1. Variadic Parameters
                                  2. Returning Values
                                    1. RETURNS Clause
                                      1. SETOF Returns
                                      2. Function Volatility
                                        1. VOLATILE Functions
                                          1. STABLE Functions
                                            1. IMMUTABLE Functions
                                            2. Language Support
                                              1. SQL Functions
                                                1. PL/pgSQL Functions
                                                  1. PL/Python Functions
                                                2. Triggers
                                                  1. Creating Triggers
                                                    1. Trigger Procedures
                                                      1. Trigger Events
                                                        1. BEFORE Triggers
                                                          1. AFTER Triggers
                                                            1. INSTEAD OF Triggers
                                                            2. Row-level Triggers
                                                              1. Statement-level Triggers
                                                                1. Transition Tables
                                                                2. Stored Procedures
                                                                  1. CREATE PROCEDURE
                                                                    1. Calling Procedures
                                                                      1. Transaction Control within Procedures
                                                                      2. Views
                                                                        1. Simple Views
                                                                          1. Updatable Views
                                                                            1. Materialized Views
                                                                              1. Creating Materialized Views
                                                                                1. Refreshing Materialized Views
                                                                                  1. Usage and Limitations

                                                                              Previous

                                                                              7. Transactions and Concurrency Control

                                                                              Go to top

                                                                              Next

                                                                              9. Security and User Management