Oracle and PostgreSQL tables and indexes

This section provides reference pages for Oracle and PostgreSQL tables and indexes.

Topics

• Case sensitivity differences for Oracle and PostgreSQL
• Common Oracle and PostgreSQL data types
• Oracle read-only tables and partitions and PostgreSQL Aurora replicas
• Oracle and PostgreSQL table constraints
• Oracle and PostgreSQL temporary tables
• Oracle triggers and PostgreSQL trigger procedure
• Oracle and PostgreSQL tablespaces and data files
• Oracle and PostgreSQL user-defined types
• Oracle unused columns and PostgreSQL ALTER TABLE statement
• Oracle virtual columns and PostgreSQL views and functions
• Overall Oracle and PostgreSQL indexes summary
• Oracle bitmap indexes and PostgreSQL bitmap
• Oracle and PostgreSQL B-tree indexes
• Oracle composite indexes and PostgreSQL multi-column indexes
• Oracle function-based indexes and PostgreSQL expression indexes
• Oracle and PostgreSQL invisible indexes
• Oracle index-organized table and PostgreSQL cluster table
• Oracle local and global partitioned indexes and PostgreSQL partitioned indexes
• Oracle automatic indexing and self-managed PostgreSQL