Category: Postgresql

  • Data Types in Postgres

    1. Numeric Types 1.1. Integer Types 1.2. Arbitrary Precision Numbers 1.3. Floating-Point Types 1.4. Serial Types 2. Monetary Types 3. Character Types 4. Binary Data Types 4.1. bytea Hex Format 4.2. bytea Escape Format 5. Date/Time Types 5.1. Date/Time Input 5.2. Date/Time Output 5.3. Time Zones 5.4. Interval Input 5.5. Interval Output 6. Boolean Type 7. Enumerated Types 7.1. Declaration of Enumerated Types 7.2. Ordering 7.3. Type Safety 7.4. Implementation Details  Geometric Types 1. Points 2. Lines 3. Line Segments 4. Boxes 5. Paths […]