Thread

1. How to escape string in Postgres?

   Igor Korot <ikorot01@gmail.com> — 2026-03-29T06:08:17Z

   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.
   

2. Re: How to escape string in Postgres?

   Laurenz Albe <laurenz.albe@cybertec.at> — 2026-03-29T06:56:04Z

   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
   
   
   
   

3. Re: How to escape string in Postgres?

   Igor Korot <ikorot01@gmail.com> — 2026-03-29T07:21:26Z

   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.
   
   
   >
   > Yours,
   > Laurenz Albe
   >
   

4. Re: How to escape string in Postgres?

   Pavel Stehule <pavel.stehule@gmail.com> — 2026-03-29T08:00:08Z

   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
   
   
   >
   > Thx.
   >
   >
   >>
   >> Yours,
   >> Laurenz Albe
   >>
   >
   

5. Re: How to escape string in Postgres?

   hubert depesz lubaczewski <depesz@depesz.com> — 2026-03-29T11:54:52Z

   On Sat, Mar 28, 2026 at 11:08:17PM -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 []?
   
   Generally you put there name of schema and table.
   
   select * from public.zzz;
   
   if your schema/table name would contain "weird" characters, then put the
   identifier inside "quotes", like:
   
   select * from "WeirdyNamedSchema"."badly named table";
   
   If that's not what you're after, you have to be more specific.
   
   Best regards,
   
   depesz