Skip site navigation (1) Skip section navigation (2)

Re: Show tablespace for databases with psql's \l+

From: Philip Yarra <philip(at)utiba(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Show tablespace for databases with psql's \l+
Date: 2006-03-30 03:32:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Thu, 30 Mar 2006 01:13 pm, Tom Lane wrote:
> Philip Yarra <philip(at)utiba(dot)com> writes:
> > Please let me know if this patch needs any changes for acceptance. I
> > would prefer the tablespace row to the left of Description,
> Me too --- that looks pretty weird as-is.

OK, revised patch attached. Less-weird output now looks like this:

                           List of databases
   Name    | Owner  | Encoding | Tablespace |        Description
 postgres  | pyarra | LATIN1   | pg_default |
 pyarra    | pyarra | LATIN1   | pg_default |
 spctest   | pyarra | LATIN1   | spctable   |
 template0 | pyarra | LATIN1   | pg_default |
 template1 | pyarra | LATIN1   | pg_default | Default template database
(5 rows)

Much nicer, I think.

Regards, Philip.


"Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it." - Brian W. Kernighan

Utiba Pty Ltd 
This message has been scanned for viruses and
dangerous content by Utiba mail server and is 
believed to be clean.

Attachment: patch-psql-db-tblspc-show2
Description: text/x-diff (1.6 KB)

In response to


pgsql-patches by date

Next:From: Guillaume SmetDate: 2006-03-30 14:22:12
Subject: Patch proposal for log_duration
Previous:From: Tom LaneDate: 2006-03-30 03:13:29
Subject: Re: Show tablespace for databases with psql's \l+

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group