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: (view raw or whole thread)
Lists: pgsql-patches
Following discussion 
( 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

                           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)


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-2015 The PostgreSQL Global Development Group