Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       CREATE TABLE AS -

SYNOPSIS

       CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ]
           AS query

DESCRIPTION

       CREATE TABLE AS  SELECT   SELECT   SELECT

       CREATE TABLE AS   SELECT   SELECT   SELECT

PARAMETERS

       TEMPORARY or TEMP
                 CREATE TABLE [create_table(7)]

       table_name

       column_name
                 EXECUTE

       query
                  SELECT    SELECT    EXECUTE    SELECT  [select(7)]   EXECUTE
              [execute(l)]

NOTES

         SELECT INTO [select_into(7)]  SELECT ... INTO

COMPATIBILITY

         Oracle   SQL   CREATE TABLE  INSERT ... SELECT

SEE ALSO

       CREATE TABLE [create_table(7)], CREATE VIEW  [create_view(l)],  EXECUTE
       [execute(l)], SELECT [select(l)], SELECT INTO [select_into(l)]

       Postgresql  <laser@pgsqldb.org>