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+
|
Список | 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 по дате отправления: