Relationship among database,schema, and table in PostgreSQL-Alibaba Cloud Developer Community

Logically, schema and table are all located under the database.

First, create a table in the postgres database (equivalent to a public schema):

[pgsql@localhost bin]$ ./psql -d postgres
psql (9.1.2)
Type "help" for help.

postgres=# createtable tab200(id integer);
CREATETABLE
postgres=# \q

then, create a table in the tester database (equivalent to a public schema):

[pgsql@localhost bin]$ ./psql -d tester
psql (9.1.2)
Type "help" for help.

tester=# createtable tab200(id integer);
CREATETABLE
tester=# \q

then, view it in another database:

[pgsql@localhost bin]$ ./psql
psql (9.1.2)
Type "help" for help.

pgsql=# SELECT*FROM information_schema.tables WHERE table_name='tab200';
 table_catalog | table_schema | table_name | table_type | self_referencing_column_name | reference_generation | user_de
fined_type_catalog | user_defined_type_schema | user_defined_type_name | is_insertable_into | is_typed | commit_action 
---------------+--------------+------------+------------+------------------------------+----------------------+--------
-------------------+--------------------------+------------------------+--------------------+----------+---------------
(0 rows)

pgsql=# \q

then, view the database in postgres and tester respectively:

[pgsql@localhost bin]$ ./psql -d tester
psql (9.1.2)
Type "help" for help.

tester=# SELECT*FROM information_schema.tables WHERE table_name='tab200';
 table_catalog | table_schema | table_name | table_type | self_referencing_column_name | reference_generation | user_de
fined_type_catalog | user_defined_type_schema | user_defined_type_name | is_insertable_into | is_typed | commit_action 
---------------+--------------+------------+------------+------------------------------+----------------------+--------
-------------------+--------------------------+------------------------+--------------------+----------+---------------
 tester        |public| tab200     | BASE TABLE|||||| YES                | NO       | 
(1 row)

tester=# \q[pgsql@localhost bin]$ ./psql -d postgres
psql (9.1.2)
Type "help" for help.

postgres=# SELECT*FROM information_schema.tables WHERE table_name='tab200';
 table_catalog | table_schema | table_name | table_type | self_referencing_column_name | reference_generation | user_de
fined_type_catalog | user_defined_type_schema | user_defined_type_name | is_insertable_into | is_typed | commit_action 
---------------+--------------+------------+------------+------------------------------+----------------------+--------
-------------------+--------------------------+------------------------+--------------------+----------+---------------
 postgres      |public| tab200     | BASE TABLE|||||| YES                | NO       | 
(1 row)

this article is transferred from brother Jian's data garden blog, original link: http://www.cnblogs.com/gaojian/p/3171301.html,如需转载请自行联系原作者

Please read this disclaimer carefully before you start to use the service. By using the service, you acknowledge that you have agreed to and accepted the content of this disclaimer in full. You may choose not to use the service if you do not agree to this disclaimer. This document is automatically generated based on public content on the Internet captured by Machine Learning Platform for AI. The copyright of the information in this document, such as web pages, images, and data, belongs to their respective author and publisher. Such automatically generated content does not reflect the views or opinions of Alibaba Cloud. It is your responsibility to determine the legality, accuracy, authenticity, practicality, and completeness of the content. We recommend that you consult a professional if you have any doubt in this regard. Alibaba Cloud accepts no responsibility for any consequences on account of your use of the content without verification. If you have feedback or you find that this document uses some content in which you have rights and interests, please contact us through this link: https://www.alibabacloud.com/campaign/contact-us-feedback. We will handle the matter according to relevant regulations.

Machine Translation: Natural Language Processing Technology - Alibaba Cloud from: Site > Product > Elastic Computing

Alibaba Cloud
Free Trial

50+ Free Offers

Relationship among database,schema, and table in PostgreSQL-Alibaba Cloud Developer Community

Start Building Today with a Free Trial to 50+ Products