To understand query locking we will take an example to know more about how locking works and how to see what’s going on within our database. Start with our own example Logging in PostgreSQL Database with pgAdmin or other tools and create a table, it will use in our example. CREATE TABLE student ( id serial NOT NULL, name character varying(36), CONSTRAINT student_pkey PRIMARY KEY (id) ); INSERT INTO student (name) VALUES ('ram'), ('mohan'), ('sohan'); Open a SQL Editor (First SQL E...
