NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit978f38c

committed

Add information about access method for partitioned relations in \dP+

Since374c7a2, it is possible to set a table AM on a partitionedtable. This information was showing up already in psql with \d+, while\dP+ provided no information.This commit extends \dP+ to show the access method used by a partitionedtable or index, if set.Author: Justin PryzbyDiscussion:https://postgr.es/m/ZkyivySXnbvOogZz@pryzbyj2023

1 parentedadeb0 commit978f38cCopy full SHA for 978f38c

File tree

1 file changed

+11

-1

lines changed

src/bin/psql
- describe.c

1 file changed

+11

-1

lines changed

`‎src/bin/psql/describe.c`

Lines changed: 11 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4113,7 +4113,7 @@ listPartitionedTables(const char reltypes, const char pattern, bool verbose)`
`4113`	`4113`	`PQExpBufferDatatitle;`
`4114`	`4114`	`PGresult*res;`
`4115`	`4115`	`printQueryOptmyopt=pset.popt;`
`4116`		`-booltranslate_columns[]= {false, false, false, false, false, false, false, false, false};`
	`4116`	`+booltranslate_columns[]= {false, false, false, false, false, false, false, false, false, false};`
`4117`	`4117`	`constchar*tabletitle;`
`4118`	`4118`	`boolmixed_output= false;`
`4119`	`4119`
`@@ -4181,6 +4181,13 @@ listPartitionedTables(const char reltypes, const char pattern, bool verbose)`
`4181`	`4181`
`4182`	`4182`	`if (verbose)`
`4183`	`4183`	`{`
	`4184`	`+/*`
	`4185`	`+ * Table access methods were introduced in v12, and can be set on`
	`4186`	`+ * partitioned tables since v17.`
	`4187`	`+ */`
	`4188`	`+appendPQExpBuffer(&buf,",\n am.amname as \"%s\"",`
	`4189`	`+gettext_noop("Access method"));`
	`4190`	`+`
`4184`	`4191`	`if (showNested)`
`4185`	`4192`	`{`
`4186`	`4193`	`appendPQExpBuffer(&buf,`
`@@ -4216,6 +4223,9 @@ listPartitionedTables(const char reltypes, const char pattern, bool verbose)`
`4216`	`4223`
`4217`	`4224`	`if (verbose)`
`4218`	`4225`	`{`
	`4226`	`+appendPQExpBufferStr(&buf,`
	`4227`	`+"\n LEFT JOIN pg_catalog.pg_am am ON c.relam = am.oid");`
	`4228`	`+`
`4219`	`4229`	`if (pset.sversion<120000)`
`4220`	`4230`	`{`
`4221`	`4231`	`appendPQExpBufferStr(&buf,`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit978f38c

File tree

1 file changed

1 file changed

`‎src/bin/psql/describe.c`

0 commit comments