diff options
| -rw-r--r-- | src/bin/psql/describe.c | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 3e542f7b1d4..f1c3d9b7e01 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2537,10 +2537,9 @@ describeOneTableDetails(const char *schemaname, { printfPQExpBuffer(&buf, "SELECT pub.pubname\n" - " FROM pg_catalog.pg_publication pub\n" - " LEFT JOIN pg_catalog.pg_publication_rel pr\n" - " ON (pr.prpubid = pub.oid)\n" - "WHERE pr.prrelid = '%s' OR pub.puballtables\n" + " FROM pg_catalog.pg_publication pub,\n" + " pg_catalog.pg_get_publication_tables(pub.pubname)\n" + "WHERE relid = '%s'\n" "ORDER BY 1;", oid); |