Skip to content

Instantly share code, notes, and snippets.

@lbalceda

lbalceda/gist:5406803

Last active December 16, 2015 08:38
Show Gist options
  • Save lbalceda/5406803 to your computer and use it in GitHub Desktop.
Save lbalceda/5406803 to your computer and use it in GitHub Desktop.
Download ZIP
modify owners of all tables or sequences in PostgreSQL
Raw
gistfile1.txt
#tables
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
#sequences
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