现在位置:首页 > 数据库 > PostgreSQL > PostgreSQL模式Schema

PostgreSQL模式Schema

来源:未知    由 admin 更新版本    浏览:人次

模式(schema)实际上一个命名表的集合。也可以包含一个schema视图,索引,序列,数据类型,运算符和函数。Schema是满足类似于在操作系统级别的目录,但该模式不能嵌套。 CREATE SCHEMA PostgreSQL语句创建一个模式(schema)。 www.yiibai.com

语法

创建型模式的基本语法如下: yiibai.com

CREATE SCHEMA name;
 www.yiibai.com 

其中,name是模式的名称。 www.yiibai.com

在Schema中创建表的语法

The basic syntax to create table in schema is as follows:

yiibai.com

CREATE TABLE myschema.mytable (
...
);
 

yiibai.com

Example

Let us see an example for creating a schema. Connect to the database testdb and create a schemamyschema as follows: www.yiibai.com

testdb=# create schema myschema;
CREATE SCHEMA
 yiibai.com 

The message "CREATE SCHEMA" signifies that the schema is created successfully. yiibai.com

Now, let us create a table in the above schema as follows: yiibai.com

testdb=# create table myschema.company(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),
   PRIMARY KEY (ID)
   );
 

www.yiibai.com

This will create an empty table. You can verify the table created with the command below:

www.yiibai.com

testdb=# select * from myschema.company;
 

www.yiibai.com

This would produce following result:

www.yiibai.com

 id | name | age | address | salary
----+------+-----+---------+--------
(0 rows)
 

www.yiibai.com

删除模式语法

To drop a schema if it's empty (all objects in it have been dropped), then use:

www.yiibai.com

DROP SCHEMA myschema;
 
yiibai.com

To drop a schema including all contained objects, use:

yiibai.com

DROP SCHEMA myschema CASCADE;
 yiibai.com 

使用模式的优势

  • It allows many users to use one database without interfering with each other.

    yiibai.com

  • It organizes database objects into logical groups to make them more manageable.

    yiibai.com

  • Third-party applications can be put into separate schemas so they do not collide with the names of other objects.

    yiibai.com

本站文章除注明转载外,均为本站原创或编译
欢迎任何形式的转载,但请务必注明出处,尊重他人劳动,传播学习教程;
转载请注明:文章转载自:易百教程 [http://www.yiibai.com]
本文标题:PostgreSQL模式Schema
转载请保留原文链接:http://www.yiibai.com/html/postgresql/2013/080441.html
上一篇:PostgreSQL删除表      下一篇:PostgreSQL INSERT查询