[prev] 15 [next]

PostgreSQL Functionality (cont)

PostgreSQL has a well-defined and open extensibility model:
  • stored procedures are held in database as strings
    • allows a variety of languages to be used
    • language interpreters can be integrated into engine
  • can add new data types, operators, aggregates, indexes
    • typically requires code written in C, following defined API
    • for new data types, need to write input/output functions, ...
    • for new indexes, need to implement file structures