How to fix Numeric value out of range in PostgreSQL

ERROR: value "9999999999" is out of range for type integer

-- View table structure
\d table_name;

-- Or query information schema
SELECT column_name, data_type, numeric_precision, numeric_scale
FROM information_schema.columns
WHERE table_name = 'your_table';

-- Change INTEGER to BIGINT
ALTER TABLE table_name ALTER COLUMN column_name TYPE BIGINT;

-- Change NUMERIC precision
ALTER TABLE table_name ALTER COLUMN column_name TYPE NUMERIC(15, 2);

-- For SERIAL to BIGSERIAL, drop and recreate the sequence
ALTER TABLE table_name DROP CONSTRAINT table_name_id_key;
ALTER TABLE table_name ALTER COLUMN id TYPE BIGINT;
CREATE SEQUENCE table_name_id_seq AS BIGINT;
ALTER TABLE table_name ALTER COLUMN id SET DEFAULT nextval('table_name_id_seq');

-- Too small: NUMERIC(5, 2) can only hold values up to 999.99
ALTER TABLE table_name ALTER COLUMN price TYPE NUMERIC(10, 2);  -- Now holds up to 99,999,999.99

-- For calculations, use a larger precision in intermediate steps
SELECT
  id,
  price,
  quantity,
  price * quantity AS total  -- Ensure this fits in result column type
FROM orders;

-- Or cast to larger type during calculation
SELECT
  id,
  CAST(price AS NUMERIC(15, 2)) * CAST(quantity AS NUMERIC(15, 2)) AS total
FROM orders;

// Node.js/JavaScript example
const MAX_INT = 2147483647;
const MIN_INT = -2147483648;

function validateIntegerColumn(value) {
  if (value > MAX_INT || value < MIN_INT) {
    throw new Error(`Value ${value} exceeds INTEGER range`);
  }
  return value;
}

// Or for NUMERIC columns
function validateNumeric(value, precision, scale) {
  const maxIntegerDigits = precision - scale;
  const maxValue = Math.pow(10, maxIntegerDigits) - 1;
  if (Math.abs(value) >= maxValue) {
    throw new Error(`Value exceeds NUMERIC(${precision}, ${scale}) range`);
  }
  return value;
}