Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is equivalent of Long data type in PostgreSQL?

I want to know what's the equivalent of Long data type in PostgreSQL?

like image 327
Mahmoud Saleh Avatar asked Jul 14 '10 10:07

Mahmoud Saleh


People also ask

Can PostgreSQL handle large data?

PostgreSQL does not impose a limit on the total size of a database. Databases of 4 terabytes (TB) are reported to exist. A database of this size is more than sufficient for all but the most demanding applications.

What is Bigint in PostgreSQL?

PostgreSQL BIGINT is numeric data type used in PostgreSQL to store integer type of values, we can store the integer type of value using bigint data type in PostgreSQL. The size of bigint data type in PostgreSQL is 8 bytes and range of bigint data type is -9223372036854775808 to 9223372036854775807.

What is the length of text in PostgreSQL?

In PostgreSQL, the text data type is used to keep the character of infinite length. And the text data type can hold a string with a maximum length of 65,535 bytes.


1 Answers

According to the docs it looks like bigint is your friend, with a range of -9223372036854775808 to 9223372036854775807.

like image 65
Jon Skeet Avatar answered Oct 20 '22 10:10

Jon Skeet