Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       CREATE SCHEMA -

SYNOPSIS

       CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]
       CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]

DESCRIPTION

       CREATE SCHEMA

          ""   current_schema

        CREATE SCHEMA   AUTHORIZATION

PARAMETERS

       schemaname

       username

       schema_element
                SQL   CREATE TABLECREATE VIEW  GRANT  CREATE SCHEMA

NOTES

         CREATE

EXAMPLES

       CREATE SCHEMA myschema;

         joe  ---  joe

       CREATE SCHEMA AUTHORIZATION joe;

       CREATE SCHEMA hollywood
           CREATE TABLE films (title text, release date, awards text[])
           CREATE VIEW winners AS
               SELECT title, release FROM films WHERE awards IS NOT NULL;

       CREATE SCHEMA hollywood;
       CREATE TABLE hollywood.films (title text, release date, awards text[]);
       CREATE VIEW hollywood.winners AS
           SELECT title, release FROM hollywood.films WHERE awards IS NOT NULL;

COMPATIBILITY

        SQL  CREATE SCHEMA  DEFAULT CHARACTER SET  PostgreSQL

        SQL  CREATE SCHEMA   PostgreSQL

         SQL  PostgreSQL   CREATE

SEE ALSO

       ALTER SCHEMA [alter_schema(7)], DROP SCHEMA [drop_schema(l)]

       Postgresql  <laser@pgsqldb.org>