Shulou(Shulou.com)06/01 Report--

At the top of its logical structure is the instance, in which multiple databases can be created, multiple schema can be created in each database, and multiple objects can be created under each schema. Objects include tables, materialized views, operators, indexes, views, sequences, functions,. Wait.

Database cannot access each other because it specifies which database to connect to when connecting. Different schema under the same database can access each other, the table name under the same schema cannot be the same, and different schema can have the same table name.

Compared with MySQL, schema under postgresql is equivalent to database under mysql.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.