Show tablespace for databases with psql's \l+

Поиск
Список
Период
Сортировка
От Philip Yarra
Тема Show tablespace for databases with psql's \l+
Дата
Msg-id 200603301034.22815.philip@utiba.com
обсуждение исходный текст
Ответы Re: Show tablespace for databases with psql's \l+  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Following discussion
(http://archives.postgresql.org/pgsql-hackers/2006-03/msg01208.php) here's a
patch to add tablespace to the output of psql's \l+. New output (with psql
-E) looks like this:

pyarra=# \l+
********* QUERY **********
SELECT d.datname as "Name",
       r.rolname as "Owner",
       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
       pg_catalog.shobj_description(d.oid, 'pg_database') as "Description",
       t.spcname as "Tablespace"
FROM pg_catalog.pg_database d
  JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
  JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid
ORDER BY 1;
**************************

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

Please let me know if this patch needs any changes for acceptance. I would
prefer the tablespace row to the left of Description, but opted for minimal
change to get patch accepted. Will re-order them if others are in favour.

Regards, Philip.

-----------------
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: restore to defaults values when commenting of variables in postgresql.conf
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: -HEAD pg_dumpall broken against older backends