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

Asked

Viewed 157 times

1

I have a table in Postgre whose Id field is Integer type and primary key. As records are saved, the numbering goes 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 aspects? Thank you :)

1 answer

2


According to the Table Numeric Types of documentation of Postgres 9.1, integer is 4 bytes that goes from -2147483648 à +2147483647

Tabela

  • Thank you @Fabricio!

Browser other questions tagged

You are not signed in. Login or sign up in order to post.