O'Reilly logo

Rails, Angular, Postgres, and Bootstrap, 2nd Edition by David B. Copeland

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required