@@ -6369,7 +6369,8 @@ getForeignDataWrappers(int *numForeignDataWrappers)
6369
6369
"fdwhandler::pg_catalog.regproc, "
6370
6370
"fdwvalidator::pg_catalog.regproc, fdwacl, "
6371
6371
"array_to_string(ARRAY("
6372
- "SELECT option_name || ' ' || quote_literal(option_value) "
6372
+ "SELECT quote_ident(option_name) || ' ' || "
6373
+ " quote_literal(option_value) "
6373
6374
"FROM pg_options_to_table(fdwoptions)), ', ') AS fdwoptions "
6374
6375
"FROM pg_foreign_data_wrapper" ,
6375
6376
username_subquery );
@@ -6381,7 +6382,8 @@ getForeignDataWrappers(int *numForeignDataWrappers)
6381
6382
"'-' AS fdwhandler, "
6382
6383
"fdwvalidator::pg_catalog.regproc, fdwacl, "
6383
6384
"array_to_string(ARRAY("
6384
- "SELECT option_name || ' ' || quote_literal(option_value) "
6385
+ "SELECT quote_ident(option_name) || ' ' || "
6386
+ " quote_literal(option_value) "
6385
6387
"FROM pg_options_to_table(fdwoptions)), ', ') AS fdwoptions "
6386
6388
"FROM pg_foreign_data_wrapper" ,
6387
6389
username_subquery );
@@ -6468,7 +6470,8 @@ getForeignServers(int *numForeignServers)
6468
6470
"(%s srvowner) AS rolname, "
6469
6471
"srvfdw, srvtype, srvversion, srvacl,"
6470
6472
"array_to_string(ARRAY("
6471
- "SELECT option_name || ' ' || quote_literal(option_value) "
6473
+ "SELECT quote_ident(option_name) || ' ' || "
6474
+ " quote_literal(option_value) "
6472
6475
"FROM pg_options_to_table(srvoptions)), ', ') AS srvoptions "
6473
6476
"FROM pg_foreign_server" ,
6474
6477
username_subquery );
@@ -11395,7 +11398,7 @@ dumpUserMappings(Archive *fout,
11395
11398
11396
11399
appendPQExpBuffer (query ,
11397
11400
"SELECT usename, "
11398
- "array_to_string(ARRAY(SELECT option_name || ' ' || quote_literal(option_value) FROM pg_options_to_table(umoptions)), ', ') AS umoptions\n"
11401
+ "array_to_string(ARRAY(SELECTquote_ident( option_name) || ' ' || quote_literal(option_value) FROM pg_options_to_table(umoptions)), ', ') AS umoptions\n"
11399
11402
"FROM pg_user_mappings "
11400
11403
"WHERE srvid = %u" ,
11401
11404
catalogId .oid );
@@ -12043,7 +12046,8 @@ dumpTableSchema(Archive *fout, TableInfo *tbinfo)
12043
12046
/* retrieve name of foreign server and generic options */
12044
12047
appendPQExpBuffer (query ,
12045
12048
"SELECT fs.srvname, array_to_string(ARRAY("
12046
- " SELECT option_name || ' ' || quote_literal(option_value)"
12049
+ " SELECT quote_ident(option_name) || ' ' || "
12050
+ " quote_literal(option_value)"
12047
12051
" FROM pg_options_to_table(ftoptions)), ', ') AS ftoptions "
12048
12052
"FROM pg_foreign_table ft JOIN pg_foreign_server fs "
12049
12053
"ON (fs.oid = ft.ftserver) "