How to escape string in Postgres?

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

Hi, Lauren’s,

On Sat, Mar 28, 2026 at 11:56 PM Laurenz Albe <laurenz.albe@cybertec.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.

Thx.

Hi

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

Hi, Lauren’s,

On Sat, Mar 28, 2026 at 11:56 PM Laurenz Albe <laurenz.albe@cybertec.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