Lock level on MERGE statement

Does anyone know what is the lock level (row, table) on PostgreSQL MERGE command? I tried to dig deep on the documentation but I couldn't find anything that could clarify my mind. If anyone have a clue and would be kind to share, that would be very appreciated.

Solution

From the manual:

ROW EXCLUSIVE Conflicts with the SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes.

The commands UPDATE, DELETE, INSERT, and MERGE acquire this lock mode on the target table (in addition to ACCESS SHARE locks on any other referenced tables). In general, this lock mode will be acquired by any command that modifies data in a table.

How can I select rows from a table where the sum of rows in a joined table is greater than a number?
Generating time series between two dates in PostgreSQL
How to ignore errors with psql \copy meta-command
PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
How to restore postgres database into another database name
Are PostgreSQL column names case-sensitive?
PHP: exec() returns status '0' (successful) when executing failing PostgreSQL scripts
Is TRUNCATE a DML statement?
Initialize PostgreSQL Container with docker-entrypoint-initdb.d script
pgadmin4 : postgresql application server could not be contacted
Adding a raw select statement to the Knex query builder
Gaps between primary key id in sql table
MSB4057: The target "GetEFProjectMetadata" does not exist in the project. .NET Core 8, Entity Framework Core 8
Prevent DateRangeField overlap in Django model?
Ruby on Rails hashed password using BCrypt not saving to postgres users table
Is it safe to set the statistics target to zero for numeric columns?
Use multiple conflict_target in ON CONFLICT clause
Retrieve similarity score in Python for HNSW vector indexing in PostgreSQL
Sequelize is chopping of nested key length
How to allow mixed integer and numeric parameters in icase
PostgreSQL copy command using STDIN
Error when Loading data into postgresql db
pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
Pivoting a table using crosstab() in PostgreSQL
Getting error recursive reference to query must not appear within its non-recursive term in postgres
dspace import metadata acknowledges changes doesn't apply them
Running the Postgres CLI client from a Kubernetes jumpbox
Problem Restoring PostgreSQL Database in Docker Container with Symfony
Postgres split time ranges into 1 minute slots, without rounding boundaries
how to store PostgreSQL jsonb using SpringBoot + JPA?