PostgreSQL 8.0.0 �����ĵ���PostgreSQL �й� ������
PrevFast BackwardFast ForwardNext

SELECT INTO

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

����

SELECT INTO ��һ����ѯ�ļ������д���һ���±� ���ݲ������ظ��ͻ��ˣ���һ�����ͨ�� SELECT ��ͬ�� �±���ֶξ��к� SELECT ������ֶ����������ͬ�������ֺ��������͡�

����

TEMPORARY �� TEMP

�������������ؼ��֣���ô�ñ�����Ϊһ����ʱ�����ġ� ��ο� CREATE TABLE ��ȡϸ�ڡ�

new_table

Ҫ�����ı�ı�����������ģʽ���Σ���

����������������� SELECT ������ϸ������

ע��

CREATE TABLE AS �����ú� SELECT INTO ���ơ� ���ǽ���ʹ�� CREATE TABLE AS �﷨�� ��Ϊ SELECT INTO ���DZ�׼�﷨�� ʵ���ϣ��������͵� SELECT INTO �Dz����� ECPG ���� PL/pgSQL ��ʹ�õģ� ��Ϊ���Ƕ� INTO �Ӿ�Ľ����Dz�ͬ�ġ� ���ң�CREATE TABLE AS �ṩ��һ�� SELECT INTO ���ṩ���ܵij�����

�� PostgreSQL 8.0 ��ǰ��SELECT INTO �����ı����ǰ��� OID�� ���� PostgreSQL 8.0�� SELECT INTO �����ı��Ƿ���� OID �� default_with_oids ���ò������ơ��������ĿǰȱʡΪ�棬�����ڽ����� PostgreSQL �汾����п��ܸij�ȱʡΪ�١�

����

����һ���±� films_recent�� ��ֵ�������� films ���������Ŀ�� 

SELECT * INTO films_recent FROM films WHERE date_prod >= '2002-01-01';

������

SQL ��׼�� SELECT INTO ��ʾѡȡ��ֵ��һ����������ı��������У� �����Ǵ���һ���±�SQL92 ���÷�ʵ���Ͼ����� ECPG ������ Chapter 29����PL/pgSQL ��Chapter 35�������;�� PostgreSQL �� SELECT INTO �����������˼����ʷԭ�� ���´������������ʹ�� CREATE TABLE AS ʵ�����Ŀ�ġ�

�ּ�

CREATE TABLE AS
PrevHomeNext
SELECTUpSET