[prev] 48 [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 PostgreSQL engine
  • new data types, operators, aggregates, indexes can be added
    • 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