postgres.email
❮

How to escape string in Postgres?

  • Jump to comment-1
    Igor Korot<ikorot01@gmail.com>
    Mar 29, 2026, 6:09 AM UTC
    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.
    View in PostgreSQL Archives →
    • Jump to comment-1
      Laurenz Albe<laurenz.albe@cybertec.at>
      Mar 29, 2026, 6:56 AM UTC
      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
      View in PostgreSQL Archives →
      • Jump to comment-1
        Igor Korot<ikorot01@gmail.com>
        Mar 29, 2026, 7:21 AM UTC
        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
        View in PostgreSQL Archives →
        • Jump to comment-1
          Pavel Stehule<pavel.stehule@gmail.com>
          Mar 29, 2026, 8:00 AM UTC
          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
          View in PostgreSQL Archives →
    • Jump to comment-1
      hubert depesz lubaczewski<depesz@depesz.com>
      Mar 29, 2026, 11:54 AM UTC
      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
      View in PostgreSQL Archives →