@@ -2934,29 +2934,29 @@ describeOneTableDetails(const char *schemaname,
29342934 {
29352935 printfPQExpBuffer (& buf ,
29362936 "SELECT pubname\n"
2937- " , NULL\n"
2938- " , NULL\n"
2937+ " , NULL\n"
2938+ " , NULL\n"
29392939 "FROM pg_catalog.pg_publication p\n"
2940- " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
2941- " JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn.pnnspid\n"
2940+ " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
2941+ " JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn.pnnspid\n"
29422942 "WHERE pc.oid ='%s' and pg_catalog.pg_relation_is_publishable('%s')\n"
29432943 "UNION\n"
29442944 "SELECT pubname\n"
2945- " , pg_get_expr(pr.prqual, c.oid)\n"
2946- " , (CASE WHEN pr.prattrs IS NOT NULL THEN\n"
2947- " (SELECT string_agg(attname, ', ')\n"
2948- " FROM pg_catalog.generate_series(0, pg_catalog.array_upper(pr.prattrs::pg_catalog.int2[], 1)) s,\n"
2949- " pg_catalog.pg_attribute\n"
2950- " WHERE attrelid = pr.prrelid AND attnum = prattrs[s])\n"
2951- " ELSE NULL END) "
2945+ " , pg_get_expr(pr.prqual, c.oid)\n"
2946+ " , (CASE WHEN pr.prattrs IS NOT NULL THEN\n"
2947+ " (SELECT string_agg(attname, ', ')\n"
2948+ " FROM pg_catalog.generate_series(0, pg_catalog.array_upper(pr.prattrs::pg_catalog.int2[], 1)) s,\n"
2949+ " pg_catalog.pg_attribute\n"
2950+ " WHERE attrelid = pr.prrelid AND attnum = prattrs[s])\n"
2951+ " ELSE NULL END) "
29522952 "FROM pg_catalog.pg_publication p\n"
2953- " JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
2954- " JOIN pg_catalog.pg_class c ON c.oid = pr.prrelid\n"
2953+ " JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
2954+ " JOIN pg_catalog.pg_class c ON c.oid = pr.prrelid\n"
29552955 "WHERE pr.prrelid = '%s'\n"
29562956 "UNION\n"
29572957 "SELECT pubname\n"
2958- " , NULL\n"
2959- " , NULL\n"
2958+ " , NULL\n"
2959+ " , NULL\n"
29602960 "FROM pg_catalog.pg_publication p\n"
29612961 "WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
29622962 "ORDER BY 1;" ,
@@ -2966,15 +2966,15 @@ describeOneTableDetails(const char *schemaname,
29662966 {
29672967 printfPQExpBuffer (& buf ,
29682968 "SELECT pubname\n"
2969- " , NULL\n"
2970- " , NULL\n"
2969+ " , NULL\n"
2970+ " , NULL\n"
29712971 "FROM pg_catalog.pg_publication p\n"
29722972 "JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
29732973 "WHERE pr.prrelid = '%s'\n"
29742974 "UNION ALL\n"
29752975 "SELECT pubname\n"
2976- " , NULL\n"
2977- " , NULL\n"
2976+ " , NULL\n"
2977+ " , NULL\n"
29782978 "FROM pg_catalog.pg_publication p\n"
29792979 "WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
29802980 "ORDER BY 1;" ,
@@ -4940,8 +4940,8 @@ listSchemas(const char *pattern, bool verbose, bool showSystem)
49404940 printfPQExpBuffer (& buf ,
49414941 "SELECT pubname \n"
49424942 "FROM pg_catalog.pg_publication p\n"
4943- " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
4944- " JOIN pg_catalog.pg_namespace n ON n.oid = pn.pnnspid \n"
4943+ " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
4944+ " JOIN pg_catalog.pg_namespace n ON n.oid = pn.pnnspid \n"
49454945 "WHERE n.nspname = '%s'\n"
49464946 "ORDER BY 1" ,
49474947 pattern );
0 commit comments