Re: Oracle vs. PostgreSQL - a comment

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Oracle vs. PostgreSQL - a comment
Date: 2020-06-05 14:19:36
Message-ID: a4079974-95c2-e81f-a3df-6bb263fe1186@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Achilleas Mantzios schrieb am 05.06.2020 um 14:05:
>> Plus PG does not directly support cross database queries using 3 part name, something
>> sqlserver excels at.
>
> Maybe because SQL server does not have real databases but schemas instead ?
> This sucks security wise.

That is wrong.

SQL Server has both: databases and schemas and it allows for standard compliant catalog.schema.table references.

I think you are confusing that with MySQL where a schema and a database are the same thing

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-05 14:31:37 Re: Possible improvement
Previous Message Adrian Klaver 2020-06-05 14:15:27 Re: Index no longer being used, destroying and recreating it restores use.