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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Philip Yarra <philip(at)utiba(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Show tablespace for databases with psql's \l+
Date: 2006-04-26 23:15:41
Message-ID: 200604262315.k3QNFfw06562@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied. Thanks.

---------------------------------------------------------------------------

Philip Yarra wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-04-27 00:06:52 Re: pgstat: delayed write of stats file
Previous Message Bruce Momjian 2006-04-26 23:02:34 Re: [PERFORM] WAL logging of SELECT ... INTO command