PostgreSQL

Installation

Data Types

PostgreSQL Data Types

  1. Boolean
  2. Character types such as char, varchar, and text.
  3. Numeric types such as integer and floating-point number.
  4. Temporal types such as date, time, timestamp, and interval
  5. UUID for storing Universally Unique Identifiers
  6. Array for storing array strings, numbers, etc.
  7. JSON stores JSON data
  8. hstore stores key-value pair
  9. Special types such as network address and geometric data.

Snippets

List all databases for a user