MIME-Version: 1.0
References: <CA+FnnTy4Zcq1YDVL0dNKsZx-wn6ncq4O-a9=ra5pN_uWg7SNRg@mail.gmail.com>
 <04093112c084e767f09ffe34fe5f184a11088899.camel@cybertec.at> <CA+FnnTxD1Vw5J1sfY8m316AFrG8JpPnMNrCo9hgTabBiTH6VCQ@mail.gmail.com>
In-Reply-To: <CA+FnnTxD1Vw5J1sfY8m316AFrG8JpPnMNrCo9hgTabBiTH6VCQ@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Sun, 29 Mar 2026 10:00:08 +0200
Message-ID: <CAFj8pRCCu5kxTrcYOzM=6jurAQbHXY+zKip-QxkG5OjtRr1WEw@mail.gmail.com>
Subject: Re: How to escape string in Postgres?
To: Igor Korot <ikorot01@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009d6d33064e25215e"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRCCu5kxTrcYOzM%3D6jurAQbHXY%2BzKip-QxkG5OjtRr1WEw%40mail.gmail.com>
Precedence: bulk

--0000000000009d6d33064e25215e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

ne 29. 3. 2026 v 9:21 odes=C3=ADlatel Igor Korot <ikorot01@gmail.com> napsa=
l:

> Hi, Lauren=E2=80=99s,
>
> On Sat, Mar 28, 2026 at 11:56=E2=80=AFPM Laurenz Albe <laurenz.albe@cyber=
tec.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 google on =E2=80=9CPostgres escaping query=E2=80=9D did=
nt produce any
> links to the docs.
>

generally, your question is not related to escaping

https://www.postgresql.org/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-IDENT=
IFIERS

Regards

Pavel


>
> Thx.
>
>
>>
>> Yours,
>> Laurenz Albe
>>
>

--0000000000009d6d33064e25215e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote gmail_quote_con=
tainer"><div dir=3D"ltr" class=3D"gmail_attr">ne 29. 3. 2026 v=C2=A09:21 od=
es=C3=ADlatel Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01=
@gmail.com</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"auto">Hi, Lauren=E2=80=99s,</div><div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 28, 2026=
 at 11:56=E2=80=AFPM Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybert=
ec.at" target=3D"_blank">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex">On Sat, 2026-03-28 at 23:0=
8 -0700, Igor Korot wrote:<br>
&gt; In MS SQL server one can write a query like so<br>
&gt; <br>
&gt; SELECT a, b, c FROM [catalog].[schema].[table];<br>
&gt; <br>
&gt; What do I use in Postgres instead of []?<br>
<br>
Normally, you read the documentation.</blockquote><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">Agreed.</div><div dir=3D"auto">However trying to googl=
e on =E2=80=9CPostgres escaping query=E2=80=9D didnt produce any links to t=
he docs.</div></div></div></blockquote><div><br></div><div>generally, your =
question is not related to escaping</div><div><br></div><div><a href=3D"htt=
ps://www.postgresql.org/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFI=
ERS">https://www.postgresql.org/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-=
IDENTIFIERS</a></div><div><br></div><div>Regards</div><div><br></div><div>P=
avel</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
"><div><div class=3D"gmail_quote"><div dir=3D"auto"><br></div><div dir=3D"a=
uto">Thx.</div><div dir=3D"auto"><br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex" dir=3D"auto"><br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div>
</blockquote></div></div>

--0000000000009d6d33064e25215e--