diff options
Diffstat (limited to '')
-rw-r--r-- | content/blog/miscellaneous/postgresql-reassign.md | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/content/blog/miscellaneous/postgresql-reassign.md b/content/blog/miscellaneous/postgresql-reassign.md index 7779c40..b794442 100644 --- a/content/blog/miscellaneous/postgresql-reassign.md +++ b/content/blog/miscellaneous/postgresql-reassign.md @@ -1,11 +1,14 @@ --- title: "Change owner on a postgresql database and all tables" -linkTitle: "Change owner on a postgresql database and all tables" date: 2012-04-20 -description: > - Change owner on a postgresql database and all tables +description: How to change owner on a postgresql database and all tables +tags: + - PostgreSQL --- +## The solution + +Here is the sequence of commande that will change the owner of all objects in a database from a user named "support" to another named "test-support": {{< highlight sh >}} ALTER DATABASE name OWNER TO new_owner 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 |