diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.3_plus/sql/view_id.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.3_plus/sql/view_id.sql index 487e59e..826723d 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.3_plus/sql/view_id.sql +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.3_plus/sql/view_id.sql @@ -1,4 +1,4 @@ {# ===== Below will provide view id for last created view ==== #} {% if data %} -SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = '{{ data.name }}'; +SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = {{ data.name|qtLiteral }}; {% endif %} diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.4_plus/sql/view_id.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.4_plus/sql/view_id.sql index 487e59e..826723d 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.4_plus/sql/view_id.sql +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/pg/9.4_plus/sql/view_id.sql @@ -1,4 +1,4 @@ {# ===== Below will provide view id for last created view ==== #} {% if data %} -SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = '{{ data.name }}'; +SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = {{ data.name|qtLiteral }}; {% endif %} diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/ppas/9.3_plus/sql/view_id.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/ppas/9.3_plus/sql/view_id.sql index 487e59e..826723d 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/ppas/9.3_plus/sql/view_id.sql +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mview/ppas/9.3_plus/sql/view_id.sql @@ -1,4 +1,4 @@ {# ===== Below will provide view id for last created view ==== #} {% if data %} -SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = '{{ data.name }}'; +SELECT c.oid, c.relname FROM pg_class c WHERE c.relname = {{ data.name|qtLiteral }}; {% endif %}