bruno-uy · May 27, 2021 13:38
diff --git a/columns_exists_redshift_table.sql b/columns_exists_redshift_table.sql
 -- You can count the rows to be equal to columns that you're checking
 SELECT *
 FROM information_schema.columns
 WHERE table_schema = '<table_schema>'
 	AND table_name = '<table_name>'
 	AND column_name IN ('<column1>', '<column2>');
	-- You can count the rows to be equal to columns that you're checking
	SELECT *
	FROM information_schema.columns
	WHERE table_schema = '<table_schema>'
	AND table_name = '<table_name>'
	AND column_name IN ('<column1>', '<column2>');