Skip to content

Instantly share code, notes, and snippets.

@maleficarum

maleficarum/ownershipChanger.sql

Created April 3, 2012 21:29
Show Gist options
  • Save maleficarum/2295604 to your computer and use it in GitHub Desktop.
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