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

Поиск
Список
Период
Сортировка
От Philip Yarra
Тема Re: Show tablespace for databases with psql's \l+
Дата
Msg-id 200603301332.40212.philip@utiba.com
обсуждение исходный текст
Ответ на Re: Show tablespace for databases with psql's \l+  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Show tablespace for databases with psql's \l+  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
On Thu, 30 Mar 2006 01:13 pm, Tom Lane wrote:
> Philip Yarra <philip@utiba.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.


Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Show tablespace for databases with psql's \l+
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Patch proposal for log_duration