Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w6k4C-004ba9-0N for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 06:56:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6k4A-00Fsg1-1i for pgsql-general@arkaria.postgresql.org; Sun, 29 Mar 2026 06:56:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w6k4A-00Fsft-0Y for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 06:56:10 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6k47-00000001mWF-3NNe for pgsql-general@lists.postgresql.org; Sun, 29 Mar 2026 06:56:10 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-48540d21f7dso40088455e9.0 for ; Sat, 28 Mar 2026 23:56:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1774767366; x=1775372166; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=8EIxmz05LAmu9xnt3VxhIL4soXDqJVDH3hQlGjpZTJY=; b=RGgg2xo28HcrO+WZW5/E7hLuXZiiCwFBXTlEkZ85DiRJAS7zoRJJyvq2lqbnn+T1mv 4W56D//Y8nUL85qNhNMjs/f2u33WYTpPVuxWTCNJCBwii+c+O79iHx21vKlKOKYc1JuJ sQmyMB7nUjp/DWZfDkvu/yQmmOyjuf4keUdBYLeDJgoIQxWuUzA5KeHk7PFpD4gf3fCQ uhiDpXNUKAf24xnYiJXFtdREvCRKP43ytWcoYmIs4gMiRsJUx5pY42uGWOPGqLXEyB7v KhxEsiOWwkfoTYrwOgqCaqm3aeD6ul2l3HunoK6Ey8PcG/cdxQcZ5mkd/dtAZwNAJTvS RN6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774767366; x=1775372166; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8EIxmz05LAmu9xnt3VxhIL4soXDqJVDH3hQlGjpZTJY=; b=SmvzYzPEu6ZbI8RMKLmfhlrTRdvpC4Y2PSZbaF3fz4BfDJy3BrRvPskPMtzb5khA4v u7LkhZ232BtnwlOD61hU7tf3fLVk6vrMJGsOt+hRBJtJiphjvte91WTfh1XAnUNIuzRo QR7mE/BiMhj5fNdAY4vkUO16HdWLYQPjzY5cmX/6SIRv/VA0KX5W8v3xUHbGTUCtJEBx Q7eTkvOVngkqnRPT5GePtyNcbCAzERP4UDXhFS6N/TeZW9cfTuc1gWJlBEbtn3iEbXbg s8swWvYhkWR8qmc17DAr/8BP/NwWHSe1eeXzQ3wce4leFUl4iyiwoc2kiNvXI0H20frR YjEA== X-Forwarded-Encrypted: i=1; AJvYcCVJNjeUBmdPr7kYYovwSOrO7O6Gyy2ZnAXtV7RggocfGQ7SUg83PA/25EqgzIQRQK8Qy0R4ee/mzFztRloj@lists.postgresql.org X-Gm-Message-State: AOJu0YyNVrkPbwBEe6TS2LwAer6So6bYhK7NcDfkej1CuzmhR4kZveH4 LZHtoFXvhxMzy1ABjLmFhTEY2XWIsuN5j+3ey2DdNY1mVFs0CnYdBxqTCcsCZgV7uic= X-Gm-Gg: ATEYQzxvyf8Renv+xNtbd1BOzrIr9BA2G+u4qjnvVigSBGjPhWobk35qH77Nkgjo25L Kd6oucHEKW7ucS7YtkEkh36ofYGGe/Dv4uaeNSzZtZdz2qvUR3Amo7M3NtWlnRxkgwjW4vUFKU7 hNRVglGLNE8XwIt1LUkr/gz5r2exrXp3Ay+L/+dvLe7NeAFKFhMIOy1HoBePMa7gqT9jTTPQNVw iqOERLKgHrNWnpDtjaSwpEzQBZkONnVoGzothNsKF5448VU3ze68jwEiON9c7f3wIB4t46qb+yD YE1kxiB0Nkd3r8nUc/CY0ezXp8VfIqfugellPIsLq5Ey2IBRM5DLrLBszwcp9ddgrREv/kV+9ma 6+qo03Tr3LY0yo1uQO7ujN9+Fjx9RoCxRa2tahyU3vXrQ7baTqpBWZeUWi2CHDaR4+UejsHXPg+ qpgdUoU+vYrJ4XzJa8gceO9KkifZyiDZ/c0KDRccBEIkica00RN7Zehp8= X-Received: by 2002:a05:600c:6612:b0:485:34b3:8589 with SMTP id 5b1f17b1804b1-48727f1fb27mr142678715e9.31.1774767365543; Sat, 28 Mar 2026 23:56:05 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:4fd5:603f:45c2:9807:c104]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43cf21e265fsm10295503f8f.1.2026.03.28.23.56.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 28 Mar 2026 23:56:05 -0700 (PDT) Message-ID: <04093112c084e767f09ffe34fe5f184a11088899.camel@cybertec.at> Subject: Re: How to escape string in Postgres? From: Laurenz Albe To: Igor Korot , "pgsql-generallists.postgresql.org" Date: Sun, 29 Mar 2026 08:56:04 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2026-03-28 at 23:08 -0700, Igor Korot wrote: > In MS SQL server one can write a query like so >=20 > SELECT a, b, c FROM [catalog].[schema].[table]; >=20 > What do I use in Postgres instead of []? Normally, you read the documentation. Yours, Laurenz Albe