Unlocking More of Postgres’s Power
For most of my career, I viewed SQL databases as dumb stores for simplistic data. Postgres has shattered that view. In this section we’ll look at Postgres’s many advanced column types, like JSON, arrays, and enumerated types. You’ll then see that Postgres supports full-text search out of the box before finishing up with the most mundane yet frequently needed tasks: CSV export.
Modeling Your Data with Advanced Column Types
Most databases store numbers and strings. For storing more advanced structures, like arrays or maps, you typically have to create them using tables. Postgres provides more advanced types to avoid doing that, and they can be a huge time-saver. Let’s go over a few of them and show how they ...
Get Rails, Angular, Postgres, and Bootstrap, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
