@@ -5884,7 +5884,8 @@ getForeignDataWrappers(int *numForeignDataWrappers)
5884
5884
appendPQExpBuffer (query ,"SELECT tableoid, oid, fdwname, "
5885
5885
"(%s fdwowner) AS rolname, fdwvalidator::pg_catalog.regproc, fdwacl,"
5886
5886
"array_to_string(ARRAY("
5887
- "SELECT option_name || ' ' || quote_literal(option_value) "
5887
+ "SELECT quote_ident(option_name) || ' ' || "
5888
+ " quote_literal(option_value) "
5888
5889
"FROM pg_options_to_table(fdwoptions)), ', ') AS fdwoptions "
5889
5890
"FROM pg_foreign_data_wrapper" ,
5890
5891
username_subquery );
@@ -5969,7 +5970,8 @@ getForeignServers(int *numForeignServers)
5969
5970
"(%s srvowner) AS rolname, "
5970
5971
"srvfdw, srvtype, srvversion, srvacl,"
5971
5972
"array_to_string(ARRAY("
5972
- "SELECT option_name || ' ' || quote_literal(option_value) "
5973
+ "SELECT quote_ident(option_name) || ' ' || "
5974
+ " quote_literal(option_value) "
5973
5975
"FROM pg_options_to_table(srvoptions)), ', ') AS srvoptions "
5974
5976
"FROM pg_foreign_server" ,
5975
5977
username_subquery );
@@ -10275,7 +10277,7 @@ dumpUserMappings(Archive *fout,
10275
10277
10276
10278
appendPQExpBuffer (query ,
10277
10279
"SELECT usename, "
10278
- "array_to_string(ARRAY(SELECT option_name || ' ' || quote_literal(option_value) FROM pg_options_to_table(umoptions)), ', ') AS umoptions\n"
10280
+ "array_to_string(ARRAY(SELECTquote_ident( option_name) || ' ' || quote_literal(option_value) FROM pg_options_to_table(umoptions)), ', ') AS umoptions\n"
10279
10281
"FROM pg_user_mappings "
10280
10282
"WHERE srvid = %u" ,
10281
10283
catalogId .oid );