setting the length of an integer column in Postgres

Question

I have a table called "User_details" in my Postgres database with a column as "Mobile_no" with data type as Integer.

Now when I try inserting an integer value of length 10, I get the following error

ERROR:  integer out of range

I know this can be resolved if i set the data type to bigint or may be even numeric(10,0) but i want to use Int as the data type.

Any possible solution to set the length of an Integer column in Postgres?

you can not store a value bigger than 2147483647 in an integer column. Switching to bigint is your only choice — user330315
– user330315, Commented Mar 14, 2018 at 12:20
There is no such thing as the "length" of an integer, only the maximum value it can store. And that is 2147483647 — user330315
– user330315, Commented Mar 14, 2018 at 12:24

Jonnathan Q · Accepted Answer · 2018-03-14 12:24:58Z

1

On PostgreSQL an integer type can hold values between -2147483648 and +2147483647 so if the value to insert is "greater than" there is no way to store it on database, only by modifying the data type for example to bigint you will be able to store greater values (bigint can hold values between -9223372036854775808 to +9223372036854775807).

Please check https://www.postgresql.org/docs/current/static/datatype-numeric.html

edited Mar 14, 2018 at 12:24

user330315

answered Mar 14, 2018 at 12:24

Jonnathan Q

3121 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

setting the length of an integer column in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related