From ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Fri, 12 Mar 2021 18:12:41 +0100
Subject: Some more articles reformatting

---
 content/blog/miscellaneous/postgresql-reassign.md | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

(limited to 'content/blog/miscellaneous/postgresql-reassign.md')

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
-- 
cgit v1.2.3