PostgreSQL supports a variety of data types:
1. Numeric Types:
– Integer (e.g. 1,2,3)
– Real (e.g. 3.1415)
– Double Precision (e.g. 2.718281828459045)
– Numeric (e.g. 12345.6789)
– Decimal (e.g. 123.45)
2. Character Types:
– Character (e.g. ‘A’)
– Character Varying (e.g. ‘Hello World’)
– Text (e.g. ‘This is a text’)
3. Date/Time Types:
– Date (e.g. ‘2021-02-19’)
– Time (e.g. ‘15:30:00’)
– Timestamp (e.g. ‘2021-02-19 15:30:00’)
– Interval (e.g. ‘1 day’)
4. Boolean Type:
– Boolean (e.g. true or false)
5. Geometric Types:
– Point (e.g. (1.5, 2.5))
– Line (e.g. [ (1.5, 2.5), (2.5, 3.5) ])
– Box (e.g. ( (1.5, 2.5), (2.5, 3.5) ))
– Circle (e.g. )
6. Network Address Types:
– Inet (e.g. ‘127.0.0.1/32’)
– Cidr (e.g. ‘127.0.0.1/24’)
7. Bit String Types:
– Bit (e.g. B’1010’)
– Bit Varying (e.g. B’1001’)
8. UUID Types:
– UUID (e.g. ‘a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11’)