maleficarum/ownershipChanger.sql

Created April 3, 2012 21:29

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

Select an option

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

Download ZIP

Masive change ownership to pgsql tables

Raw

ownershipChanger.sql

select 'alter table '|| tablename ||' owner to ;' from pg_tables where schemaname = 'public';

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