diff options
| author | Julien Dessaux | 2021-03-12 18:12:41 +0100 |
|---|---|---|
| committer | Julien Dessaux | 2021-03-12 18:13:45 +0100 |
| commit | ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7 (patch) | |
| tree | cd93f66cd66f8ca6efe91882d8a46ca6b09bdc72 /content/blog/miscellaneous/postgresql-reassign.md | |
| parent | Improved home speech (diff) | |
| download | www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.tar.gz www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.tar.bz2 www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.zip | |
Some more articles reformatting
Diffstat (limited to 'content/blog/miscellaneous/postgresql-reassign.md')
| -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 |