select_into.sql « sql « regress « test « src - postgresql.git - This is the main PostgreSQL git repository.

index : postgresql.git

This is the main PostgreSQL git repository.

git repository user

summary refs log tree commit diff

path: root/src/test/regress/sql/select_into.sql

blob: 993c44b727d0d9954394434d23c3079bd74956aa (plain)

--
-- SELECT_INTO
--

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

DROP TABLE tmp1;

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

DROP TABLE tmp1;