Re: How to escape string in Postgres?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to escape string in Postgres?
Date: 2026-03-29 08:00:08
Message-ID: CAFj8pRCCu5kxTrcYOzM=6jurAQbHXY+zKip-QxkG5OjtRr1WEw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

ne 29. 3. 2026 v 9:21 odesílatel Igor Korot <ikorot01(at)gmail(dot)com> napsal:

> Hi, Lauren’s,
>
> On Sat, Mar 28, 2026 at 11:56 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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 “Postgres escaping query” didnt 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-IDENTIFIERS

Regards

Pavel

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2026-03-29 11:54:52 Re: How to escape string in Postgres?
Previous Message Igor Korot 2026-03-29 07:21:26 Re: How to escape string in Postgres?