On 6/5/20 10:02 AM, Achilleas Mantzios wrote:
> 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.
I manage SQL Server instances with multiple databases, each with multiple
schemas.
--
Angular momentum makes the world go 'round.