bastman · June 25, 2020 07:49
diff --git a/find_duplicate_row_ids.sql b/find_duplicate_row_ids.sql
 SELECT my_id, COUNT(my_id) 
 FROM my_table
 GROUP BY my_id
 HAVING COUNT(my_id) > 1;
diff --git a/show_tables_with_missing_primary_keys.sql b/show_tables_with_missing_primary_keys.sql
 select table_name, table_schema from information_schema."tables"
 where table_name not in (
 select table_name from information_schema.table_constraints where constraint_type='PRIMARY KEY'

 ) and table_schema='public';
	select table_name, table_schema from information_schema."tables"
	where table_name not in (
	select table_name from information_schema.table_constraints where constraint_type='PRIMARY KEY'

	) and table_schema='public';