Linux/Postgres: Difference between revisions

From Wiki
m (Marcluer moved page Postgres to Linux/Postgres)
mNo edit summary
Line 23: Line 23:
[[Category:Linux/Services]]
[[Category:Linux/Services]]
[[Category:Linux]]
[[Category:Linux]]
[[Category:Programming]]

Revision as of 15:15, 28 September 2024

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