Skip to content

Instantly share code, notes, and snippets.

@mkolb

mkolb/gist:3054048

Created July 5, 2012 14:32
Show Gist options
  • Save mkolb/3054048 to your computer and use it in GitHub Desktop.
Save mkolb/3054048 to your computer and use it in GitHub Desktop.
Download ZIP
changing permissions/ownership in postgres
Raw
gistfile1.sh
for tbl in`psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB`; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done
for tbl in`psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" YOUR_DB`; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done
for tbl in`psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" YOUR_DB`; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment