PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Peter van Hardenberg
Day Talks - Day 2 - 2016-05-20
Room DMS 1160
Start time 15:00
Duration 00:45
ID 940
Event type Lecture
Track Applications
Language used for presentation English

Overlooked Data Types

A study of useful lesser-known data types.

Everyone knows how to tell a TIMESTAMP from a TEXT, but how deep into the catalogue of Postgres data types have you gone? In this talk, we'll push past the best-known types into the pantheon of useful but less-appreciated data types Postgres has to offer, including both some that come bundled with Postgres, some you can define for yourself, and some that are available today as extensions.

Postgres has a huge variety of data types available, some built-in and some only packaged as extensions. We're going to look at both, including showing how, why, and when each of them is useful.

Some of the data types we'll look at include:

  • arrays, and row types
  • range types
  • URI
  • email
  • geospatial types (from PostGIS)
  • and more

This content will assume that you know your way around the basics of a database but we'll briefly explain any other topics required to take advantage of these types.