clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1716905 fiddles created (23834 in the last week).

CREATE TABLE test ( id int GENERATED BY DEFAULT AS IDENTITY, t text DEFAULT 'foo' );
 hidden batch(es)


WITH w AS (INSERT INTO test (t) VALUES (DEFAULT) RETURNING t ) INSERT INTO test (t) SELECT w.t FROM w CROSS JOIN generate_series(1, 1);
1 rows affected
 hidden batch(es)


SELECT * FROM test;
id t
1 foo
2 foo
 hidden batch(es)