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

Show tablespace for databases with psql's \l+

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 (view raw or flat)
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: patch-psql-db-tblspc-show
Description: text/x-diff (1.6 KB)

Responses

pgsql-patches by date

Next:From: Andrew DunstanDate: 2006-03-30 01:09:04
Subject: Re: -HEAD pg_dumpall broken against older backends
Previous:From: David FetterDate: 2006-03-29 22:25:08
Subject: Re: Win32 sysconfig -> pg_service.conf

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