public inbox for [email protected]  

help / color / mirror / Atom feed
From: Pavel Stehule <[email protected]>
To: Igor Korot <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: How to escape string in Postgres?
Date: Sun, 29 Mar 2026 10:00:08 +0200
Message-ID: <CAFj8pRCCu5kxTrcYOzM=6jurAQbHXY+zKip-QxkG5OjtRr1WEw@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTxD1Vw5J1sfY8m316AFrG8JpPnMNrCo9hgTabBiTH6VCQ@mail.gmail.com>
References: <CA+FnnTy4Zcq1YDVL0dNKsZx-wn6ncq4O-a9=ra5pN_uWg7SNRg@mail.gmail.com>
	<[email protected]>
	<CA+FnnTxD1Vw5J1sfY8m316AFrG8JpPnMNrCo9hgTabBiTH6VCQ@mail.gmail.com>

Hi

ne 29. 3. 2026 v 9:21 odesílatel Igor Korot <[email protected]> napsal:

> Hi, Lauren’s,
>
> On Sat, Mar 28, 2026 at 11:56 PM Laurenz Albe <[email protected]>
> 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
>>
>


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: How to escape string in Postgres?
  In-Reply-To: <CAFj8pRCCu5kxTrcYOzM=6jurAQbHXY+zKip-QxkG5OjtRr1WEw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox