postgresql
  1. postgresql-integer
PreviousNext

Integer - (PostgreSQL Data Types)

In PostgreSQL, Integer is a data type that is used to store whole numbers. It is a 32-bit signed integer with a range of -2147483648 to 2147483647. In this tutorial, we'll discuss the syntax, example, output, explanation, use, important points, and summary of the Integer data type in PostgreSQL.

Syntax

integer

Example

Let's create a table with an Integer column and insert some values into it.

CREATE TABLE example_table (
  id integer,
  name text
);

INSERT INTO example_table (id, name)
VALUES
  (1, 'John'),
  (2, 'Jane'),
  (3, 'Bob');

Output

After running the above SQL commands, the example_table table will be created with two columns: id (an integer data type) and name (a text data type). The table will have three rows with values (1, 'John'), (2, 'Jane'), and (3, 'Bob').

Explanation

In this example, we created a table with an Integer column named id and a text column named name. We then inserted three rows into the table using the INSERT INTO command.

The Integer data type in PostgreSQL is a 32-bit signed integer with a range of -2147483648 to 2147483647. It is commonly used for storing whole numbers.

Use

The Integer data type in PostgreSQL is used to store whole numbers. It is commonly used for storing values such as IDs, counts, and other numeric data that does not require decimal precision.

Important Points

  • Integer is a 32-bit signed integer with a range of -2147483648 to 2147483647.
  • Integer values can be used in mathematical calculations.
  • When using Integer values in arithmetic calculations with other data types, PostgreSQL will automatically convert the other data type to an Integer value before performing the calculation. If the conversion fails due to data type incompatibility, an error will occur.

Summary

In this tutorial, we discussed the Integer data type in PostgreSQL. We covered the syntax, example, output, explanation, use, and important points of the Integer data type. With this knowledge, you can now use the integer data type in PostgreSQL to store whole numbers in your PostgreSQL databases.

BooleanSMALLLINT
Published on: