Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w6jL6-004awL-0q for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 06:09:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6jK3-00FlVm-20 for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 06:08:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w6jK3-00FlVd-0i for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 06:08:31 +0000 Received: from mail-yx1-xb12a.google.com ([2607:f8b0:4864:20::b12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6jK1-00000001bRS-2X84 for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 06:08:30 +0000 Received: by mail-yx1-xb12a.google.com with SMTP id 956f58d0204a3-65009bfdcfdso1328774d50.2 for ; Sat, 28 Mar 2026 23:08:29 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774764508; cv=none; d=google.com; s=arc-20240605; b=CQA3G5hvmfVqsn/xn2x6lOg8izijwyhKkGMrM1ppI8B7sEiBKBqvFNE+Z0rQwW2W/t zpYr2n6K18RkHcf14kJoml8HzUOWD1rcJYf7Uc5rOOWNxpvfPqUe8GFnqVhVu6AQHDIx miLH6JeyJc//0reITrfpNSUIpVE5MI35EfU3oU1MwdwfQhuyeoMUPUb1HYuEKbcpkDn+ 5FALiLU9bnUs38QlDXmKYXlHXnsbxP39hzK2n+KoJ5GPI9Z9Jc+XYUgEEntSgQDDl+hf iA/9L8gxA7MRB46K1v3O/y/MHEVwVNkrkBcrDd5548NJkNXx7CFLKvyJGI3hA6d+Q/XF DapA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=lGZqct7cNqzWNuFjlc8cXwlMmNUExKQC/iZCU7qBY4A=; fh=2DoGC78b0mi8uZ4UY+9ocPF86GSVzeaJWqou/x907js=; b=fMGXuC3ZihIWpusxqVe2Fl7Z5+o1vV2cGfKD0WTV1LrEHfiVIdksv+I87bg7JkncAV SP3Nl7gQh04FzwEDgnyhl1f/FtKnUsK0pA9kNewmz7Sx7pCvQtvWIiD6Wp+2/DWkRd6S jnebkZTxNmN02vbqSEoC2MeZV0bhkqIaOYhwO899yly+6V/UyHbDprjM3onKBafBf4cP Y0PXwA7p5cnr03zIT94qF2YVvwSY0crWnM0Z8X3WwFDFkb7P5E0clVFCZ1FmMWRLQ3pC QfQTA6HkqPzgUXBjSyoz+JeMDwRRlmtsrAGwdsJbLSRn50oqNhBPh8U+MIbLvt67tt0h qiIw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774764508; x=1775369308; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=lGZqct7cNqzWNuFjlc8cXwlMmNUExKQC/iZCU7qBY4A=; b=pYz2aBKefBIi7k6lYpyD14BQlOq8Lr/PesEjEloPK5x56kTStMOMRChbnLKpQpKI2y 7O/kOAlblpLA67+cRi8DMd+AsRHSt5Whk9e/IADy05y1TDnlI4v0tcjgehYcIkS6HWyl 6853vbI1X2yo2J0fAEC4uRiRaCvAsZVI83mzGI9P2BNvJ2Q+xoPC/vPVQWv2/y4gjo1O t72D5p29QCXZX9158856FjmEHW8IAoWQIS/6bkaK6xpLvWxENKtPQua1U1Bf1qgOvpEI vxdZsN5D3aGGRLtC4UP3JNWCX8JfWNuMSMqyXoplnLq00VHfaeu40TJ059RY6NFxf+n7 7FBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774764508; x=1775369308; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lGZqct7cNqzWNuFjlc8cXwlMmNUExKQC/iZCU7qBY4A=; b=lXI3+ibGId2JV8go9g9WQVMt+hCmnh9b68158JqOCdKrBgeltR3OGLB3cV4GDXKSP3 e+V0duYMItJzc8TRSnHz4WfO/3kxxC8m09k1/2F/jZQ5Lq9I3K3/S4flvpUS5d8UC99N 2AIMTmrt4r5iJYTg+GdhEiZua0ZR+tzi4k2ktJZwDkaAF+7qjPqJD8cllir0M0W5+v7I wAcMQtailPCJE4/CQVx5Dia1zXdYn6QVSU5Q51Es5aY2X2b+qPcpB+5f9DDbt7brJlN/ pSSiOcax6ZeiyNAN8LEKtVGhAy9i3gs5r+vQJ9SvDiLnoxNkuQ6Vslpr0KzaIO6ASbP3 nOIg== X-Gm-Message-State: AOJu0YyHtM0I6u29nYKkqF2eNM8vCgnfStku1axj5DrBMx+HBayrR0xB TZDhRVeruKMIx8Av6FGdySgjFrX22YMA6oyvAO/Ej53w+28kjQd/bXsXfL+qiIm2KEFdcnRagvy 6AbOvw4x4FTg6wkaC+zQdO07BoL7oKTThpQ== X-Gm-Gg: ATEYQzxfQNViufq1M1fzrwo/oFwsrBVQWtE+tddP8tR9GP23I5Pvy5jpNlOGQQ9LW5j Fyfk2HNG1IzNEZFXsbKkavg9O9n5gB1zWNKS+3LBMPJCoEC6A5ns8tJ4Bpot6COfDp6WlI7RDro 4pf/Wd5LaZ7mFWsUK6QQsIvGNP57u4M/566XaEn3L5P7w3GV/Y1e+BuGP2NWRnMaLTnnr5x/gKD +y3lFdOXx56b7dt3DwiZkYW6kVUhOeFjYf9zGiKLZOHy7VBDTP7phM/+GJs7GYkBeeakbO0nuMx j6cK+hUnLcKBrO7GumzGxYpHDeJ3zlESMJyu7KrWZBVc7oFj3V/uymK/nNrrwuebvB2BX93yw7Q 9m1Uegl8= X-Received: by 2002:a05:690c:ed5:b0:79b:d941:dda0 with SMTP id 00721157ae682-79bddcbf4abmr89820347b3.1.1774764508411; Sat, 28 Mar 2026 23:08:28 -0700 (PDT) MIME-Version: 1.0 From: Igor Korot Date: Sat, 28 Mar 2026 23:08:17 -0700 X-Gm-Features: AQROBzBOEw47Jj3nVGuetJa_sNB-R6DPWOxserSYKihImGQ6GZ2fmCMnw36IND4 Message-ID: Subject: How to escape string in Postgres? To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000158041064e239014" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000158041064e239014 Content-Type: text/plain; charset="UTF-8" Hi, In MS SQL server one can write a query like so SELECT a, b, c FROM [catalog].[schema].[table]; What do I use in Postgres instead of []? Thank you. --000000000000158041064e239014 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi,

In MS SQL server one can w= rite a query like so

SEL= ECT a, b, c FROM [catalog].[schema].[table];

What do I use in Postgres instead of []?

Thank you.

--000000000000158041064e239014--