| 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
>>
>
| 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? |