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
• 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