Functions for Manipulating Data in PostgreSQL

Learn about the properties and characteristics of common data types including strings, numerics and arrays and how to retrieve information about your database.

Explore how to manipulate and query date and time objects including how to use the current timestamp in your queries, extract subfields from existing date and time fields and what to expect when you perform date and time arithmetic.

Learn how to manipulate string and text data by transforming case, parsing and truncating text and extracting substrings from larger strings.

An introduction into some more advanced capabilities of PostgreSQL like full-text search and extensions.