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

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 (view raw or flat)
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

pgsql-patches by date

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

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