Re: Oracle vs. PostgreSQL - a comment - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Oracle vs. PostgreSQL - a comment
Date
Msg-id a4079974-95c2-e81f-a3df-6bb263fe1186@gmx.net
Whole thread Raw
In response to Re: Oracle vs. PostgreSQL - a comment  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Oracle vs. PostgreSQL - a comment
List 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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Index no longer being used, destroying and recreating it restoresuse.
Next
From: Tom Lane
Date:
Subject: Re: Possible improvement