hoge.sql

CREATE TEMP TABLE hoge (id integer, name text);

  WITH t(id, name) AS (VALUES (1, 'hoge'), (2, 'fuga'), (3, 'piyo'))
     , t2 AS (INSERT INTO hoge SELECT id, name FROM t)
INSERT INTO hoge SELECT id * 10, name FROM t;

SELECT * FROM hoge;

-- id | name
-- ----+------
-- 10 | hoge
-- 20 | fuga
-- 30 | piyo
-- 1 | hoge
-- 2 | fuga
-- 3 | piyo
-- (6 rows)