Re: [HACKERS] psql \db+ lack of size column

2014-07-14 Thread Alvaro Herrera
Fabrízio de Royes Mello wrote:
 On Fri, May 16, 2014 at 2:03 AM, Fabrízio de Royes Mello 
 fabriziome...@gmail.com wrote:
 
  Hi all,
 
  Are there some reason to don't show the tablespace size in the \db+
  psql command?
 
 The attached patch show tablespace size in \db+ psql command.

Thanks, pushed.

-- 
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training  Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] psql \db+ lack of size column

2014-05-18 Thread Fabrízio de Royes Mello
On Fri, May 16, 2014 at 2:03 AM, Fabrízio de Royes Mello 
fabriziome...@gmail.com wrote:

 Hi all,

 Are there some reason to don't show the tablespace size in the \db+ psql
command?


The attached patch show tablespace size in \db+ psql command.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
 Timbira: http://www.timbira.com.br
 Blog sobre TI: http://fabriziomello.blogspot.com
 Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
 Twitter: http://twitter.com/fabriziomello
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 951b7ee..282cd43 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -176,6 +176,11 @@ describeTablespaces(const char *pattern, bool verbose)
 		  ,\n  spcoptions AS \%s\,
 		  gettext_noop(Options));
 
+	if (verbose  pset.sversion = 90200)
+		appendPQExpBuffer(buf,
+		  ,\n  pg_catalog.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS \%s\,
+		  gettext_noop(Size));
+
 	if (verbose  pset.sversion = 80200)
 		appendPQExpBuffer(buf,
 		 ,\n  pg_catalog.shobj_description(oid, 'pg_tablespace') AS \%s\,

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] psql \db+ lack of size column

2014-05-15 Thread Fabrízio de Royes Mello
Hi all,

Are there some reason to don't show the tablespace size in the \db+ psql
command?

Regards,

-- 
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
 Timbira: http://www.timbira.com.br
 Blog sobre TI: http://fabriziomello.blogspot.com
 Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
 Twitter: http://twitter.com/fabriziomello