SELECT INTO(7)                   SQL Commands                   SELECT INTO(7)

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 29<?><?>PL/pgSQL  <?>Chapter 35<?><?><?><?><?><?>
       PostgreSQL <?> SELECT INTO <?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?> CREATE TABLE AS <?><?><?><?><?><?><?>
       (CREATE TABLE AS
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>)

<?><?>
       Postgresql <?><?><?><?> <?><?><?> <laser@pgsqldb.org>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

SQL - Language Statements         2003-11-02                    SELECT INTO(7)