PostgreSQL 教程

1分钟

PostgreSQL 命令-SELECT INTO

从一个查询的结果中定义一个新表。

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 table_name [, ...] ] ]

上一节: PostgreSQL 命令-SELECT 下一节: PostgreSQL 命令-SET

直播支持申请

目录

评价

推荐

1. PostgreSQL 教程

PostgreSQL 介绍

什么是数据库？

ORDBMS 术语

PostgreSQL 特征

PostgreSQL 语法’

SQL 语句

PostgreSQL 命令-ABORT

PostgreSQL 命令-ALTER AGGREGATE

PostgreSQL 命令-ALTER COLLATION

PostgreSQL 命令-ALTER CONVERSION

PostgreSQL 命令-ALTER DATABASE

PostgreSQL 命令-ALTER DEFAULT PRIVILEGES

PostgreSQL 命令-ALTER DOMAIN

PostgreSQL 命令-ALTER FUNCTION

PostgreSQL 命令-ALTER GROUP

PostgreSQL 命令-ALTER INDEX

PostgreSQL 命令-ALTER LANGUAGE

PostgreSQL 命令-ALTER OPERATOR

PostgreSQL 命令-ALTER OPERATOR CLASS

PostgreSQL 命令-ALTER SCHEMA

PostgreSQL 命令-ALTER SEQUENCE

PostgreSQL 命令-ALTER TABLE

PostgreSQL 命令-ALTER TABLESPACE

PostgreSQL 命令-ALTER TRIGGER

PostgreSQL 命令-ALTER TYPE

PostgreSQL 命令-ALTER USER

PostgreSQL 命令-ANALYZE

PostgreSQL 命令-BEGIN

PostgreSQL 命令-CHECKPOINT

PostgreSQL 命令-CLOSE

PostgreSQL 命令-CLUSTER

PostgreSQL 命令-COMMENT

PostgreSQL 命令-COMMIT

PostgreSQL 命令-COPY

PostgreSQL 命令-CREATE AGGREGATE

PostgreSQL 命令-CREATE CAST

PostgreSQL 命令-CREATE CONSTRAINT TRIGGER

PostgreSQL 命令-CREATE CONVERSION

PostgreSQL 命令-CREATE DATABASE

PostgreSQL 命令-CREATE DOMAIN

PostgreSQL 命令-CREATE FUNCTION

PostgreSQL 命令-CREATE GROUP

PostgreSQL 命令-CREATE INDEX

PostgreSQL 命令-CREATE LANGUAGE

PostgreSQL 命令-CREATE OPERATOR

PostgreSQL 命令-CREATE OPERATOR CLASS

PostgreSQL 命令-CREATE ROLE

PostgreSQL 命令-CREATE RULE

PostgreSQL 命令-CREATE SCHEMA

PostgreSQL 命令-CREATE SERVER

PostgreSQL 命令-CREATE SEQUENCE

PostgreSQL 命令-CREATE TABLE

PostgreSQL 命令-CREATE TABLE AS

PostgreSQL 命令-CREATE TABLESPACE

PostgreSQL 命令-CREATE TRIGGER

PostgreSQL 命令-CREATE TYPE

PostgreSQL 命令-CREATE USER

PostgreSQL 命令-CREATE VIEW

PostgreSQL 命令-DEALLOCATE

PostgreSQL 命令-DECLARE

PostgreSQL 命令-DELETE

PostgreSQL 命令-DROP AGGREGATE

PostgreSQL 命令-DROP CAST

PostgreSQL 命令-DROP CONVERSION

PostgreSQL 命令-DROP DATABASE

PostgreSQL 命令-DROP DOMAIN

PostgreSQL 命令-DROP FUNCTION

PostgreSQL 命令-DROP GROUP

PostgreSQL 命令-DROP INDEX

PostgreSQL 命令-DROP LANGUAGE

PostgreSQL 命令-DROP OPERATOR

PostgreSQL 命令-DROP OPERATOR CLASS

PostgreSQL 命令-DROP ROLE

PostgreSQL 命令-DROP RULE

PostgreSQL 命令-DROP SCHEMA