public inbox for [email protected]  

help / color / mirror / Atom feed

How to escape string in Postgres?
4+ messages / 3 participants
[nested] [flat]

* How to escape string in Postgres?
@ 2026-03-29 06:08  Igor Korot <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Igor Korot @ 2026-03-29 06:08 UTC (permalink / raw)
  To: pgsql-generallists.postgresql.org <[email protected]>

Hi,

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

Thank you.


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: How to escape string in Postgres?
@ 2026-03-29 06:56  Laurenz Albe <[email protected]>
  parent: Igor Korot <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Laurenz Albe @ 2026-03-29 06:56 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

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.

Yours,
Laurenz Albe






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: How to escape string in Postgres?
@ 2026-03-29 07:21  Igor Korot <[email protected]>
  parent: Laurenz Albe <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Igor Korot @ 2026-03-29 07:21 UTC (permalink / raw)
  To: Laurenz Albe <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>

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.

Thx.


>
> Yours,
> Laurenz Albe
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: How to escape string in Postgres?
@ 2026-03-29 08:00  Pavel Stehule <[email protected]>
  parent: Igor Korot <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Pavel Stehule @ 2026-03-29 08:00 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: Laurenz Albe <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2026-03-29 08:00 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-29 06:08 How to escape string in Postgres? Igor Korot <[email protected]>
2026-03-29 06:56 ` Laurenz Albe <[email protected]>
2026-03-29 07:21   ` Igor Korot <[email protected]>
2026-03-29 08:00     ` Pavel Stehule <[email protected]>

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