PostgreSQL Database

  1. Data Types
    1. Numeric Types
      1. Integer Types
        1. smallint
          1. integer
            1. bigint
            2. Arbitrary Precision Numbers
              1. numeric
                1. decimal
                2. Floating-Point Types
                  1. real
                    1. double precision
                    2. Serial Types
                      1. smallserial
                        1. serial
                          1. bigserial
                        2. Character Types
                          1. varchar
                            1. char
                              1. text
                              2. Binary Data Types
                                1. bytea
                                2. Date and Time Types
                                  1. timestamp with time zone
                                    1. timestamp without time zone
                                      1. date
                                        1. time with time zone
                                          1. time without time zone
                                            1. interval
                                            2. Boolean Type
                                              1. Geometric Types
                                                1. point
                                                  1. line
                                                    1. lseg
                                                      1. box
                                                        1. path
                                                          1. polygon
                                                            1. circle
                                                            2. Network Address Types
                                                              1. cidr
                                                                1. inet
                                                                  1. macaddr
                                                                    1. macaddr8
                                                                    2. Special Types
                                                                      1. JSON
                                                                        1. JSONB
                                                                          1. XML
                                                                            1. UUID
                                                                              1. Arrays
                                                                                1. Composite Types
                                                                                  1. Range Types
                                                                                    1. Enumerated Types
                                                                                    2. Type Conversion and Casting
                                                                                      1. Domain Types

                                                                                      Previous

                                                                                      3. SQL Fundamentals in PostgreSQL

                                                                                      Go to top

                                                                                      Next

                                                                                      5. Advanced Querying