@@ -2934,29 +2934,29 @@ describeOneTableDetails(const char *schemaname,
2934
2934
{
2935
2935
printfPQExpBuffer (& buf ,
2936
2936
"SELECT pubname\n"
2937
- " , NULL\n"
2938
- " , NULL\n"
2937
+ " , NULL\n"
2938
+ " , NULL\n"
2939
2939
"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"
2942
2942
"WHERE pc.oid ='%s' and pg_catalog.pg_relation_is_publishable('%s')\n"
2943
2943
"UNION\n"
2944
2944
"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) "
2952
2952
"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"
2955
2955
"WHERE pr.prrelid = '%s'\n"
2956
2956
"UNION\n"
2957
2957
"SELECT pubname\n"
2958
- " , NULL\n"
2959
- " , NULL\n"
2958
+ " , NULL\n"
2959
+ " , NULL\n"
2960
2960
"FROM pg_catalog.pg_publication p\n"
2961
2961
"WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
2962
2962
"ORDER BY 1;" ,
@@ -2966,15 +2966,15 @@ describeOneTableDetails(const char *schemaname,
2966
2966
{
2967
2967
printfPQExpBuffer (& buf ,
2968
2968
"SELECT pubname\n"
2969
- " , NULL\n"
2970
- " , NULL\n"
2969
+ " , NULL\n"
2970
+ " , NULL\n"
2971
2971
"FROM pg_catalog.pg_publication p\n"
2972
2972
"JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
2973
2973
"WHERE pr.prrelid = '%s'\n"
2974
2974
"UNION ALL\n"
2975
2975
"SELECT pubname\n"
2976
- " , NULL\n"
2977
- " , NULL\n"
2976
+ " , NULL\n"
2977
+ " , NULL\n"
2978
2978
"FROM pg_catalog.pg_publication p\n"
2979
2979
"WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
2980
2980
"ORDER BY 1;" ,
@@ -4940,8 +4940,8 @@ listSchemas(const char *pattern, bool verbose, bool showSystem)
4940
4940
printfPQExpBuffer (& buf ,
4941
4941
"SELECT pubname \n"
4942
4942
"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"
4945
4945
"WHERE n.nspname = '%s'\n"
4946
4946
"ORDER BY 1" ,
4947
4947
pattern );
0 commit comments