PostGre - Field Id (Integer) of a table can go from 1 to how much?

1

I have a table in PostGre whose Id field is of type Integer and primary key. As records are being saved, numbering ranges from 1 to how much?

I'm used to the Dataflex database, where table records (by default) start from 1 and go up to 999999.

Is there a difference between PostGre and SQL Server in these respects? Thanks:)

    
asked by anonymous 20.06.2018 / 15:04

1 answer

2

According to the Numeric Types table of documentation Postgres 9.1, integer is 4 bytes from -2147483648 to +2147483647

    
20.06.2018 / 15:12