# PostgreSQL Data Types

DevFeed: [PostgreSQL Data Types](<https://devfeed.tech/articles/postgresql-data-types-34598.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/05/postgresql-data-types/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-05-24T12:47:05Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [JOIN](<https://devfeed.tech/topics/join.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Regular expression](<https://devfeed.tech/topics/regular-expression.md>)

Tags: [data-type](<https://devfeed.tech/tags/data-type.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [join](<https://devfeed.tech/tags/join.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [regexp](<https://devfeed.tech/tags/regexp.md>), [reporting](<https://devfeed.tech/tags/reporting.md>)

## AI overview

A recap of a series on PostgreSQL data types, covering how types provide input validation, expected behaviors, and processing functions. It reviews examples involving booleans, text encoding and processing, date and time values, and network address types.

## Source excerpt

Today it's time to conclude our series of PostgreSQL Data Types articles with a recap. The series cover lots of core PostgreSQL data types and shows how to benefit from the PostgreSQL concept of a data type: more than input validation, a PostgreSQL data type also implements expected behaviors and processing functions. This allows an application developer to rely on PostgreSQL for more complex queries, having the processing happen where the data is, for instance when implementing advanced JOIN operations, then retrieving only the data set that is interesting for the application.