# Lesser Known PostgreSQL Features

DevFeed: [Lesser Known PostgreSQL Features](<https://devfeed.tech/articles/lesser-known-postgresql-features-33926.md>)

Original publisher: [Read original article](<https://hakibenita.com/postgresql-unknown-features>)

Author: Haki Benita

Published: 2021-11-07T22:00:00Z

Content type: tutorial

Language: en

Sources: [Haki Benita](<https://devfeed.tech/sources/haki-benita.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [articles](<https://devfeed.tech/tags/articles.md>), [etl](<https://devfeed.tech/tags/etl.md>), [features](<https://devfeed.tech/tags/features.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

## AI overview

This article presents lesser-known PostgreSQL features, including a command for synchronizing table data and a technique for distinguishing inserted rows from updated rows using a system column. It also discusses logging ETL processes.

## Source excerpt

A list of useful features you already have, but may not know about! In this article I share lesser known features of PostgreSQL.