Description
A PostgreSQL Datatypes is a programming language, which contain set of values and data. A PostgreSQL Datatypes defines an appropriate kind of data and data type also defines the attainable values for that type, the operations that should be possible on that sort and then stored the data.
PostgreSQL Datatypes are classified into the following types. They are as follows:
- Numeric
- Binary
- Character
- Monetary
- Date/time
- Boolean
Description
These numeric datatypes consists of integers and floating point numbers.
| Types | Explanation | Size |
|---|---|---|
| Integer | For integers there will be common decision. | Stores 4 bytes. |
| Decimal | Based on client precision. | Stores based on variable size. |
| Numeric | Based on client precision. | Stores based on variable size. |
| Smallint | The range of integers is very small. | Stores 2 bytes in size. |
| Bigint | The range of integer is very large. | Stores 8 bytes in size. |
| Double precision | Depands on the precision variable. | Store 8 bytes in size. |
| Serial | Inters will get auto increment. | Stores 4 bytes in size. |
| Real | Depands on the precision of variables. | Stores 4 bytes in size. |
Description
These binary datatype contain bytea data that stores only the strings that are binary.
| Type | Explanation | Size |
|---|---|---|
| Bytea | Contains the binary string variable length. | Store the string that is real and contains the bytes length of 1 or 4. |
Description
In character datatype variable, it display the character values that are used for general usage.
| Type | Explanation |
|---|---|
| Text | Variable length is unlimited. |
| Character varying(n),varchar(n) | There is a limit in the length of the variable. |
| Character(n),char(n) | Here the length of the variable is fixed. |
Description
The cash sort stores the amount in currency with a settled fragmentary exactness. Estimations of the int, numeric, and bigint information sorts can be thrown to cash.
| Type | Explanation | Size |
|---|---|---|
| Money | Amount in currency. | Storges in 8 bytes. |
Description
Here in the data and time datatype, PostgreSQL will supports all the features of SQL datatype.
| Type | Explanation | Size |
|---|---|---|
| Timestamp[(p)][with time zone] | Exists time and data along the time zone. | Stores 8 bytes in size. |
| Timestamp[(p)][without time zone] | Exits only time and date. | Stores 8 bytes in size. |
| Time[(p)][Doesn't contain the time zone] | day time. | Stores 8 bytes in size. |
| Time[(p)] having time zone. | day time along with the time zone. | Stores 12 bytes in size. |
| Date. | date. | Stores 4 bytes in size. |
Description
Here in the boolean datatype the standard boolean types of SQL are used. And there are several types of boolean types exists such as true, false and unknown. Which represent the null values of SQL.
| Types | Explanation | Size |
|---|---|---|
| Boolean | Determines wheather the set is true or false. | Stores one byte in size. |
Key Points
- PostgreSQL Datatypes - Is a programming language.
- Numeric datatype - Consists of integer and floating point numbers.
- Binary datatype - Contain bytea data.
- Character datatype - Display character values.
- Monetary datatype - Evaluates int,numeric and bigint.
- Date/Time datatype - Supports the features of SQL database.
- Boolean datatypes - The standard boolean types of SQL are used.