Skip to content
masterclass Buddy
Start learning

PostgreSQL · Type Alias

numeric

numeric stores exact decimal values with user-selected precision and scale. It is suited to money and other data where rounding errors are not acceptable.

Last updated

Since
15

Syntax

NUMERIC(precision, scale)
NUMERIC(precision)
NUMERIC

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • decimal
  • integer
  • real
  • double precision
  • smallint
  • bigint

Source: PostgreSQL: Documentation: 18: 8.1. Numeric Types. Checked 2026-11-03.