PGCon2016 - 20180510
PGCon 2016
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Peter van Hardenberg |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2016-05-20 |
| Room | DMS 1160 |
| Start time | 15:00 |
| Duration | 00:45 |
| Info | |
| 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
- JSONB
- URI
- 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.