diff options
author | Michael Paquier <michael@paquier.xyz> | 2020-09-02 16:59:22 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2020-09-02 16:59:22 +0900 |
commit | 07f386ede026ae8c3f2adeba0c22139df19bf2ff (patch) | |
tree | 456a86e1a3d5e14b22b4a28b26c2aa72bbc839cf /doc/src | |
parent | 01767533e37fa255722cc0088ed67a0309875963 (diff) | |
download | postgresql-07f386ede026ae8c3f2adeba0c22139df19bf2ff.tar.gz postgresql-07f386ede026ae8c3f2adeba0c22139df19bf2ff.zip |
Add access method names to \d[i|m|t]+ in psql
Listing a full set of relations with those psql meta-commands, without a
matching pattern, has never showed the access method associated with
each relation. This commit adds the access method of tables, indexes
and matviews, masking it for relation kinds where it does not apply.
Note that when HIDE_TABLEAM is enabled, the information does not show
up. This is available when connecting to a backend version of at least
12, where table AMs have been introduced.
Author: Georgios Kokolatos
Reviewed-by: Vignesh C, Michael Paquier, Justin Pryzby
Discussion: https://postgr.es/m/svaS1VTOEscES9CLKVTeKItjJP1EEJuBhTsA0ESOdlnbXeQSgycYwVlliL5zt8Jwcfo4ATYDXtEqsExxjkSkkhCSTCL8fnRgaCAJdr0unUg=@protonmail.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 201946990f4..e1e2236a71d 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1183,7 +1183,9 @@ testdb=> columns of the table are shown, as is the presence of OIDs in the table, the view definition if the relation is a view, a non-default <link linkend="sql-createtable-replica-identity">replica - identity</link> setting. + identity</link> setting and the + <link linkend="sql-create-access-method">access method</link> name + if the relation has an access method. </para> <para> |