# PostgreSQL Data Types: Point

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

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

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-05-07T08:46:17Z

Content type: tutorial

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [data](<https://devfeed.tech/tags/data.md>), [point](<https://devfeed.tech/tags/point.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A tutorial introducing PostgreSQL's Point data type through the download, loading, processing, and normalization of GeoNames geolocation data. It uses SQL and discusses handling problematic quoting and reference data.

## Source excerpt

Continuing our series of PostgreSQL Data Types today we're going to introduce the PostgreSQL Point type. In order to put the Point datatype in a context where it makes sense, we're going to download a complete geolocation data set and normalize it, thus making good use of both the normalization good practice and those other PostgreSQL data types we've been learning about in the previous articles of this series. Buckle-up, this is a long article with a lot of SQL inside.