PostgreSQL: Get ROW_COUNT of Last Executed Query Like MS SQL @@ROWCOUNT In Microsoft SQL Server, @@ROWCOUNT returns the number of rows affected by the most recent SQL statement. PostgreSQL doesn’t use @@ROWCOUNT, but provides a similar way to get the affected row count using the GET DIAGNOSTICS statement. :contentReference[oaicite:0]{index=0} What is ROW_COUNT in PostgreSQL? In PostgreSQL, the equivalent of MSSQL’s @@ROWCOUNT is the ROW_COUNT value retrieved via GET DIAGNOSTICS . This captures the number of rows impacted by the last INSERT , UPDATE , or DELETE statement executed in a PL/pgSQL block. :contentReference[oaicite:1]{index=1} Example: Using GET DIAGNOSTICS The following example shows how to update records and capture the number of rows affected: DO $$ DECLARE v_RowCountInt INTEGER; BEGIN UPDATE usermst SET emailid = 'abc@gmail.com'; GET DIAGNOSTICS v_RowCountInt = ROW_COUNT; RAISE NOTICE 'Rows affected: %', v_RowCountInt;...

PostgreSQL: Convert Multiple Rows to JSON PostgreSQL supports powerful JSON functions that let you convert regular table rows into JSON format. This is especially useful when building APIs, exporting data, or preparing structured output for web applications. Understanding JSON Functions in PostgreSQL PostgreSQL includes several JSON functions, and one of the most useful for transforming multiple rows into JSON output is row_to_json() . This function turns a single row into a JSON object. :contentReference[oaicite:0]{index=0} Example Table and Sample Data Suppose we create a sample table to demonstrate how multiple rows can be exported as JSON. CREATE TABLE UserMst ( code INTEGER, name VARCHAR(100), status VARCHAR(50) ); INSERT INTO UserMst (code, name, status) VALUES (1001, 'Jacob', 'Active'), (1002, 'William', 'In-Active'), (1003, 'Sophia', 'Active'); Convert Every Row to a JSON Object Use the following SQL que...