From: | Philip Yarra <philip(at)utiba(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Show tablespace for databases with psql's \l+ |
Date: | 2006-03-30 00:34:22 |
Message-ID: | 200603301034.22815.philip@utiba.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
Attachment | Content-Type | Size |
---|---|---|
patch-psql-db-tblspc-show | text/x-diff | 1.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-03-30 01:09:04 | Re: -HEAD pg_dumpall broken against older backends |
Previous Message | David Fetter | 2006-03-29 22:25:08 | Re: Win32 sysconfig -> pg_service.conf |