Several concepts of PostgreSQL

The top level of its logical structure is the instance, where multiple databases can be created in the instance, and multiple schemas may 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 a minute.

Database can not access each other, because at the time of the connection to specify which database, the same database under the different schema may be accessible to each other, the same schema under the table name can not be the same, different schema under the same table name.

Compared to MySQL, the schema under PostgreSQL is equivalent to the database under MySQL.

Several concepts of PostgreSQL