4 ms·
The PostgreSQL usage of schema is consistent with the ANSI sql definition. MSSQL is the same.
by sitharus 5y ago
The PostgreSQL usage of schema is consistent with the ANSI sql definition. MSSQL is the same.
- chungy 5y agoI think most people surprised at the PostgreSQL model of databases and schemas are coming from a MySQL/MariaDB background where the terms are synonymous. PostgreSQL matches the model of basically every non-MySQL database when it comes to these concepts. Though if we talk about database weirdness, I never liked Oracle DB's insistence that databases and users are the same thing. Glad I haven't used it for well over a decade now :)
- chousuke 5y agoI was actually surprised that you can query across databases in MySQL, but that makes sense once you understand that there's only one database and the "databases" are just schemas.
- progre 5y agoComing from MSSQL I was equally surprised that you cant query across databases in postgres even if they are on the the same server. Yeah there is the Foreign Data Wrapper thing but the DBA was very reluctant to enable it or whatever.