ophentis/dbclean.sql

Created April 9, 2017 17:20

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ophentis/812fac5eb9f0589c16b8666a9a1a87d7.js"></script>
Save ophentis/812fac5eb9f0589c16b8666a9a1a87d7 to your computer and use it in GitHub Desktop.

Download ZIP

postgresql drop table generator

Raw

dbclean.sql

	select 'drop table if exists "' \|\| tablename \|\| '" cascade;'
	from pg_tables
	where schemaname = 'public'; -- or any other schema

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment