gaurangrshah · April 7, 2021 00:41
diff --git a/create-enum.sql b/create-enum.sql
 CREATE TYPE enum_name AS ENUM ('value1', 'value2', 'value3', 'value4');

 -- DROP TYPE admin_level1;
diff --git a/reset-autoincrement.sql b/reset-autoincrement.sql
 ALTER SEQUENCE media_id_seq RESTART WITH 1

 -- resets auto table id generator count
diff --git a/truncate.sql b/truncate.sql
 TRUNCATE TABLE table_name;

 -- removes table content as long as it is not being refrenced by another table.
	CREATE TYPE enum_name AS ENUM ('value1', 'value2', 'value3', 'value4');

	-- DROP TYPE admin_level1;
	ALTER SEQUENCE media_id_seq RESTART WITH 1

	-- resets auto table id generator count
	TRUNCATE TABLE table_name;

	-- removes table content as long as it is not being refrenced by another table.