Skip to content

Instantly share code, notes, and snippets.

@kellyredding

kellyredding/pg_reassign.sql

Created December 14, 2012 23:51
Show Gist options
  • Save kellyredding/4289686 to your computer and use it in GitHub Desktop.
Save kellyredding/4289686 to your computer and use it in GitHub Desktop.
Download ZIP
Mass-modify owner roles for an entire db in Postgres. I used this when changing a db user an app uses to access its data.
Raw
pg_reassign.sql
REASSIGN OWNED BY old_role [, ...] TO new_role
@kellyredding
Copy link
Author

(notes to self)
http://stackoverflow.com/a/13535184
http://www.postgresql.org/docs/9.2/static/sql-reassign-owned.html

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