On 5/6/20 5:19 μ.μ., Thomas Kellerer wrote:
> 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
I think that you are confusing what you think I am confusing. I am talking about our MS SQL installation here at work.
Notdone by me anyways I am the pgsql guy, but still do most of the query stuff
in ms sql as well.
I wrote already that my comment was far fetched in a subsequent email.
>
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt