select_into.sql

来自「关系型数据库 Postgresql 6.5.2」· SQL 代码 · 共 15 行

SELECT *
   INTO TABLE tmp1
   FROM tmp
   WHERE onek.unique1 < 2;

DROP TABLE tmp1;

SELECT *
   INTO TABLE tmp1
   FROM tmp
   WHERE onek2.unique1 < 2;

DROP TABLE tmp1;