openGauss SQL参考—SQL语法：SELECT INTO（2）

示例

--将tpcds.reason表中r_reason_sk小于5的值加入到新建表中。
openGauss=# SELECT * INTO tpcds.reason_t1 FROM tpcds.reason WHERE r_reason_sk < 5;
INSERT 0 6

--删除tpcds.reason_t1表。
openGauss=# DROP TABLE tpcds.reason_t1;

相关链接

SELECT