Simon Wrigley wriglz

## find_duplicate_rows_postgres.sql
WITH data AS
  (SELECT column_to_test,
          count(*) OVER (PARTITION BY column_to_test), other_columns_to_output
   FROM schema.table )
SELECT *
FROM data
WHERE count > 1
ORDER BY column_to_test;

## delete_lines_from_txt_file_containing_specific_string.sh
# Directly modify file & create a backup
sed -i.bak '/pattern to match/d' ./input_file

# Directly modify file - no backup
sed -i '' '/pattern to match/d' ./infile

## drop_all_connections.sql
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB' -- ← change this to your DB
  AND pid <> pg_backend_pid();

## rename_multiple_columns.sql
-- Call function with the schema name
CREATE OR REPLACE FUNCTION rename_columns(_schema text) RETURNS VOID AS $func$
DECLARE
rec RECORD;
table RECORD;
result RECORD;
sql TEXT := '';
i INTEGER;

BEGIN
	WITH data AS
	(SELECT column_to_test,
	count(*) OVER (PARTITION BY column_to_test), other_columns_to_output
	FROM schema.table )
	SELECT *
	FROM data
	WHERE count > 1
	ORDER BY column_to_test;
	# Directly modify file & create a backup
	sed -i.bak '/pattern to match/d' ./input_file

	# Directly modify file - no backup
	sed -i '' '/pattern to match/d' ./infile
	SELECT pg_terminate_backend(pg_stat_activity.pid)
	FROM pg_stat_activity
	WHERE pg_stat_activity.datname = 'TARGET_DB' -- ← change this to your DB
	AND pid <> pg_backend_pid();
	-- Call function with the schema name
	CREATE OR REPLACE FUNCTION rename_columns(_schema text) RETURNS VOID AS $func$
	DECLARE
	rec RECORD;
	table RECORD;
	result RECORD;
	sql TEXT := '';
	i INTEGER;

	BEGIN