# PostgreSQL Concurrency: Data Modification Language

DevFeed: [PostgreSQL Concurrency: Data Modification Language](<https://devfeed.tech/articles/postgresql-concurrency-data-modification-language-34599.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/06/postgresql-concurrency-data-modification-language/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-06-25T07:58:53Z

Content type: tutorial

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [consistency](<https://devfeed.tech/topics/consistency.md>)

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

## AI overview

This introductory PostgreSQL tutorial explains how the database handles concurrent access while maintaining consistency. It demonstrates basic SQL Data Manipulation Language operations, including inserting rows, inserting query results, and alternatives such as COPY and transactions for larger inserts.

## Source excerpt

PostgreSQL is a relational database management system. It's even the world's most advanced open source one of them. As such, as its core, Postgres solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. Postgres exposes its concurrency APIs in the SQL language, in particular in the DML parts of it: you can read the Data Manipulation Language chapter of the PostgreSQL docs for all the details.