Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       SELECT INTO -

SYNOPSIS

       SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
           * | expression [ AS output_name ] [, ...]
           INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
           [ FROM from_item [, ...] ]
           [ WHERE condition ]
           [ GROUP BY expression [, ...] ]
           [ HAVING condition [, ...] ]
           [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
           [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
           [ LIMIT { count | ALL } ]
           [ OFFSET start ]
           [ FOR UPDATE [ OF tablename [, ...] ] ]

DESCRIPTION

       SELECT INTO   SELECT   SELECT

PARAMETERS

       TEMPORARY  TEMP
                 CREATE TABLE [create_table(7)]

       new_table

         SELECT [select(7)]

NOTES

       CREATE  TABLE  AS  [create_table_as(7)]   SELECT INTO   CREATE TABLE AS
       SELECT INTO   SELECT INTO  ECPG  PL/pgSQL   INTO

COMPATIBILITY

        SQL   SELECT  ...  INTO    ECPG    Chapter  29PL/pgSQL    Chapter   35
       PostgreSQL  SELECT INTO   CREATE TABLE AS  (CREATE TABLE AS )

       Postgresql  <laser@pgsqldb.org>