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 1w6kSt-004c4D-0V for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 07:21:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6kSq-00Fxmh-0H for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 07:21:40 +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 1w6kSp-00FxmZ-1q for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 07:21:40 +0000 Received: from mail-yx1-xb12d.google.com ([2607:f8b0:4864:20::b12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6kSn-00000001bye-36N9 for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 07:21:38 +0000 Received: by mail-yx1-xb12d.google.com with SMTP id 956f58d0204a3-64ea73e7b60so4207887d50.3 for ; Sun, 29 Mar 2026 00:21:37 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774768897; cv=none; d=google.com; s=arc-20240605; b=DjvfWRubk9jrHZANzrPCBFf7fTZRdUCYYByUfbyVn3MaDLIu52DwiQ9CFAJhxtMt3J pZUAoWsYdzLKzTWPIlW+eA3CYFhfzWGKwBIe7VhgoK0tjKx6L9+m8aLAy86YhUIjH0VQ MC4472xZN+FAv95zfS39HRWa0E4dQSYVdkvt6qvnF+wkE0kn637eXpTgiY5t3CilySDy QytNyeP5ooYQiXO6MPZWJAVBFNgkCstWBpF1sJcwzEqDfJrIsK2q2/4GSrxhUObMHK2W b3caTxpzFpnVEc673au/urPtUf7S5Bf49OZZOHKVy6/gwyTl0V9Ms4M2ikJw3cyPL9wq ty4w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=akRUOuBeupOz78BMSVeil0iaxI5sEJr7vIRGH1ksgI4=; fh=2u6Ez/XdNYXKOmumPCqKn/IaCMVB7T+u0pbjZVc+TwE=; b=R3J+MZlxl6EhCz6Ce6m4Tbsc7djATnoaLt6XkTXW3N+5Krt2N0W5UVv6aoMj/BwK7a kuGaujv/NDxhyvBGt4jcT9V7w2J+baECY67gaKvaacVqmqL+mVnkrq2oE+VnOlkyToFY hpvtRXgnn1aCgi3MscZ5OgJms9OFussZbd32EahFdURzsDSmREfttotJxLtrxC/1bTnS KUk5amOJaatiVW/imOtVaeQzYx8eHWqnpstt5JL/SwHTomHvz+6uF6mu3nm0iDovNXOB L4ORMCgBaDER9ErX+dw45hXcHAxDFWsCCMNl3p39uBrkVf50Z5ya3y3wvLDGpIQdC2EA YAqA==; 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=1774768897; x=1775373697; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=akRUOuBeupOz78BMSVeil0iaxI5sEJr7vIRGH1ksgI4=; b=GtXveZxSS6p7OqsU+b+oBs52LfBCrZbuvXEQA71z7WYOxLsfs4rR2A4t6xnG1KjV5m spdM1SB2uERS/TzY3laWFiIWSWjlzYSPC1XILrMEJ9Rw0BWQ9wQPNbvrPTl7/T102MQM fuP9AgqLS+56cYuo2V0pdLa15YdpjMwFdXQwR6IJ7MkNTGF2NGxwkd85vpXu0ZRos6y8 cbQTish+HJZZ/9KOAOEzIsQMVSQEhRGJKhhucR1fiE599oQPcdOS4RoperhPs3tkHjOe 2m1iJqjq8iK4sfWHqL2lq7ccGMzG/ZWngkLfqrPyxWZEYfps4pxFnL2ZpMnbqwIOT6tD 8Ziw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774768897; x=1775373697; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=akRUOuBeupOz78BMSVeil0iaxI5sEJr7vIRGH1ksgI4=; b=d59o1Ep7dBCqkmE6mTgpf3LUTiah2t1XJCbYvqvIstyGswBGjGdMROzaIXiMAlMztG fKtOXnkjG7s81fZqF4GXJMlmhe8+3j0p/vGUGjS+XeH7a6u0WhNYPFXuMaWN/lHeBC7q C0m5EqO3whrDUesrypMlD9ri9PTCy26L7P0tqHQYesTrnQ6gI4lenDD2J/Ab5WJrG3+M buFoPnP+8Y90tE0uysw3K5mP9IJdviisjSX7lwS6qcsj+/nhm4BQSByHcPZfL3k5C0S9 9LVt7/rOL01hbcbZBDNP6Uq39QUWnBiqoWhKHnucUJpGnceXTQB30Hlr4wotKtgKDZj9 T6mg== X-Gm-Message-State: AOJu0YxYVD1yq/xmW7S/vuXz5oNtDBz4v+gS/sEc5m1SXPRGCgQbKsxH IuZUf41fiV1M7DrAWOSU5i5+eRaiuuWQawIrgQEU1nmvgBqE18fH7QRX8xwliUWRTW9b6+kvpMk l1y64eqlbmfYPEBBGjJNQmIYL6XUf5J0= X-Gm-Gg: ATEYQzzPqi/AYZL5gYanJUHG2Ltf5sE7NH9uvNAlN5l0GTCtLc7qPBFFmiZjV7/X2s0 gvSA3WPaMpCJQOScl9vo4Ezvn7TrSXkYPxRf/j/g89ucUfAzipnraqhDVHPZuWgnU8hgNcfpS4X 3E88Hbo+qjjtk4Le7xqs49EZkulyfq++sYQkPj9cBp+PkDdS6wgLYoFW731UG6k0FDfz7lxIoyD Bzy2w0o6rMT0aVqYxEwxzAmg6etUsY3432LSYy+IdpsULkz8mpqGsCIwYXR2qg60ivLbWGwI9ge YyD1iAulbZxUU4M1eKaQeTOOmT/YTvFjFO7y8EK+4jz261hZTUIG03Kts0z4dAljKy7oFtLs X-Received: by 2002:a05:690c:d83:b0:79a:c7f8:d95c with SMTP id 00721157ae682-79bde04f909mr87768807b3.40.1774768897022; Sun, 29 Mar 2026 00:21:37 -0700 (PDT) MIME-Version: 1.0 References: <04093112c084e767f09ffe34fe5f184a11088899.camel@cybertec.at> In-Reply-To: <04093112c084e767f09ffe34fe5f184a11088899.camel@cybertec.at> From: Igor Korot Date: Sun, 29 Mar 2026 00:21:26 -0700 X-Gm-Features: AQROBzAknwMzPhJN-dGa2x4CRPF2JioyqqM-iD8GAKgFZLrZmYegHCzGsQxSgbg Message-ID: Subject: Re: How to escape string in Postgres? To: Laurenz Albe Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000aa6201064e2495a8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000aa6201064e2495a8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Lauren=E2=80=99s, On Sat, Mar 28, 2026 at 11:56=E2=80=AFPM Laurenz Albe wrote: > On Sat, 2026-03-28 at 23:08 -0700, Igor Korot wrote: > > 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 []? > > Normally, you read the documentation. Agreed. However trying to google on =E2=80=9CPostgres escaping query=E2=80=9D didnt= produce any links to the docs. Thx. > > Yours, > Laurenz Albe > --000000000000aa6201064e2495a8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, Lauren=E2=80=99s,

On Sat, M= ar 28, 2026 at 11:56=E2=80=AFPM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Sat, 2026-03-28 at 23:08 -0700, Igor Korot wrote:=
> 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 []?

Normally, you read the documentation.

Agreed.
However trying to googl= e on =E2=80=9CPostgres escaping query=E2=80=9D didnt produce any links to t= he docs.

Thx.



Yours,
Laurenz Albe
--000000000000aa6201064e2495a8--