PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
Speakers | |
---|---|
Jim Mlodgenski | |
Jonathan S. Katz |
Schedule | |
---|---|
Day | Tutorials - Day 1 - 2013-05-21 |
Room | MRT 256 |
Start time | 13:00 |
Duration | 03:00 |
Info | |
ID | 633 |
Event type | Workshop |
Track | Tutorial |
Language used for presentation | English |
PostgreSQL Data Types
Data types like you never saw them before A Whirlwind Tour of PostgreSQL Data Types
What's the great thing about a database? Why, it stores data of course! However, one feature that makes a database useful is the different data types that can be stored in it, and the breadth and sophistication of the data types in PostgreSQL is second-to-none, including some novel data types that do not exist in any other type of database software!
This tutorial will take an in-depth look at all of the native data types built right into PostgreSQL as of version 9.2 (with some peeking ahead to 9.3). We will take a look at the functionality provided with each data type, examples of how they are used both in theory and practice, and of course, best practices that demonstrate the robustness of PostgreSQL.
Some of the data types that will be covered are:
- Date / Time (which the presenters prefer manipulating in PostgreSQL)
- Arrays
- Geometric Types
- JSON / XML
- Range Types
- UUIDs
- Fulltext Search types
- Composite and Custom Typing
We will also demonstrate some data type extensions that are available to the PostgreSQL.