From c0c1b69b4924d64ce5df4bc7c8a229cc73a8b6c5 Mon Sep 17 00:00:00 2001 From: Euler Taveira Date: Mon, 18 Jan 2021 12:09:19 -0300 Subject: [PATCH v12 3/5] Print publication WHERE condition in psql --- src/bin/psql/describe.c | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index eeac0efc4f..983ba512f7 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -6038,7 +6038,8 @@ describePublications(const char *pattern) if (!puballtables) { printfPQExpBuffer(&buf, - "SELECT n.nspname, c.relname\n" + "SELECT n.nspname, c.relname,\n" + " pg_get_expr(pr.prqual, c.oid)\n" "FROM pg_catalog.pg_class c,\n" " pg_catalog.pg_namespace n,\n" " pg_catalog.pg_publication_rel pr\n" @@ -6068,6 +6069,10 @@ describePublications(const char *pattern) PQgetvalue(tabres, j, 0), PQgetvalue(tabres, j, 1)); + if (!PQgetisnull(tabres, j, 2)) + appendPQExpBuffer(&buf, " WHERE %s", + PQgetvalue(tabres, j, 2)); + printTableAddFooter(&cont, buf.data); } PQclear(tabres); -- 2.20.1