Обсуждение: How to escape string in Postgres?
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.
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.
Yours,
Laurenz Albe
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
Regards
Pavel
Thx.
Yours,
Laurenz Albe
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