Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Data types in Postgres

Data type LengthDescription
bigint 8 Integer from -2^63 (-9 223 372 036 854 775 808) to 2^63-1 (9 223 372 036 854 775 807)
integer 4 Integer from -2^31 (-2 147 483 648) to 2^31-1 (2 147 483 647)
smallint 2 Integer from -2^15 (-32 768) to 2^15-1 (32 767)
tinyint 1 Integer from 0 to 255
bit 1 bit Integer 0 or 1.
boolean 1 Integer 0 or 1 or unknown (null)
decimal(precision, scale) n Numeric data type with fixed precision and scale (up to 131072 digits before the decimal point and up to 16383 digits after the deciomal point).
numeric(precision, scale) n The same as decimal data type.
real 4 Numeric data type with float precision to 6 decimal positions.
double precision 8 Numeric data type with float precision to 15 decimal positions.
money 8 Financial data type from -92233720368547758.08 to +92233720368547758.07.
timestamp (precision) 8 Time and date without time zone, where the accuracy can be entered as 0 (whole seconds) to 6 (microseconds).
timestamptz (precision) 8 Time and date with time zone, where the accuracy can be entered as 0 (whole seconds) to 6 (microseconds).
char(n) n Text string of fixed length (maximum length: 8000 characters)
varchar(n) n Text string of variable length (maximum length: 8000 characters)
text unlimited Text string of variable length (maximum length: 2^31-1 = 2 147 483 647 characters)
 
See https://www.postgresql.org/docs/11/datatype.html.

History:
Pm8.02.00: Created
PROMOTIC 9.0.15 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice