Linux/Postgres

From Wiki
< Linux
Revision as of 15:15, 28 September 2024 by Marcluer (talk | contribs)

PostgreSQL data types

  • boolean
  • char(n)
  • varchar(n)
  • text
  • smallint (-32768 - 32767)
  • int
  • serial (~auto_increment in mysql)
  • float(n)
  • real / float8
  • numeric(p,s)
  • date
  • time
  • timestamp
  • timestamptz
  • interval
  • json
  • jsonb
  • uuid
  • + special