Skip to content

Faker().postgreSQL

dictionary file 
en:
  faker:
    database:
      postgresql:
        data_type:
          # Numeric
          - SMALLINT
          - INTEGER
          - BIGINT
          - DECIMAL
          - NUMERIC
          - REAL
          - DOUBLE PRECISION
          - BOOLEAN

          # Date and Time
          - TIMESTAMP
          - TIMESTAMP WITH TIME ZONE
          - DATE
          - TIME
          - TIME WITH TIME ZONE

          # Character Strings
          - CHARACTER
          - CHARACTER VARYING
          - TEXT
          - ENUM

          # Binary
          - BYTEA

          # Spatial
          - POINT
          - LINE
          - LSEG
          - BOX
          - PATH
          - POLYGON
          - CIRCLE

          # JSON
          - JSON
          - JSONB

          # Network Address
          - INET
          - CIDR
          - MACADDR
          - MACADDR8

          # Other
          - ARRAY
          - UUID

Faker().postgreSQL.dataType() // => VARCHAR

Faker().postgreSQL.collation() // => en_US.UTF-8