create_table_as man page on BSDi

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDi logo
[printable version]

CREATE TABLE AS()		 SQL Commands		     CREATE TABLE AS()

NAME
       CREATE TABLE AS - Creates a new table from the results of a SELECT

SYNOPSIS
       CREATE [ TEMPORARY | TEMP ] TABLE table [ (column [, ...] ) ]
	    AS select_clause

   INPUTS
       TEMPORARY or TEMP
	      If specified, the table is created only within this session, and
	      is automatically dropped on session  exit.   Existing  permanent
	      tables  with  the	 same  name  are not visible (in this session)
	      while the temporary table exists.	 Any indexes created on a tem‐
	      porary table are automatically temporary as well.

       table  The  name	 of  the new table to be created.  This table must not
	      already exist. However, a temporary table can  be	 created  that
	      has the same name as an existing permanent table.

       column The  name	 of  a	column. Multiple column names can be specified
	      using a comma-delimited list of column names.  If	 column	 names
	      are not provided, they are taken from the output column names of
	      the SELECT query.

       select_clause
	      A valid query statement.	Refer  to  SELECT  [select(l)]	for  a
	      description of the allowed syntax.

   OUTPUTS
       Refer  to  CREATE  TABLE [create_table(l)] and SELECT [select(l)] for a
       summary of possible output messages.

DESCRIPTION
       CREATE TABLE AS creates a table and fills it with data  computed	 by  a
       SELECT  command. The table columns have the names and datatypes associ‐
       ated with the output columns of the SELECT (except that you  can	 over‐
       ride  the  SELECT  column  names	 by  giving an explicit list of column
       names).

       CREATE TABLE AS bears some resemblance to creating a view,  but	it  is
       really quite different: it creates a new table and evaluates the SELECT
       just once to fill the new table initially. The new table will not track
       subsequent  changes  to the source tables of the SELECT. In contrast, a
       view re-evaluates the given SELECT whenever queried.

       This   command	is   functionally   equivalent	  to	SELECT	  INTO
       [select_into(l)],  but  it  is  preferred since it is less likely to be
       confused with other uses of the SELECT ... INTO syntax.

SQL - Language Statements	 29 March 2001		     CREATE TABLE AS()
[top]

List of man pages available for BSDi

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net