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. Not done 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
