What are the main PostgreSQL data types?

Beginner

Answer

PostgreSQL supports various data types:

  • Numeric: INTEGER, BIGINT, DECIMAL, NUMERIC, REAL, DOUBLE PRECISION
  • Character: CHAR, VARCHAR, TEXT
  • Date/Time: DATE, TIME, TIMESTAMP, INTERVAL
  • Boolean: BOOLEAN
  • Binary: BYTEA
  • JSON: JSON, JSONB
  • Arrays: Any data type can be an array
  • UUID: Universally Unique Identifiers
  • Network: INET, CIDR for IP addresses