clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
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. 709926 fiddles created (14148 in the last week).

CREATE TABLE tbl ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY , foo text DEFAULT 'bar' , CONSTRAINT foo_bar CHECK (foo IN ('bar', 'bar1')) ); INSERT INTO tbl(foo) VALUES (DEFAULT), ('bar1');
2 rows affected
 hidden batch(es)


TABLE tbl;
id foo
1 bar
2 bar1
 hidden batch(es)


CREATE TEMP TABLE t_tbl (LIKE tbl INCLUDING ALL); INSERT INTO t_tbl TABLE tbl; SELECT setval(pg_get_serial_sequence('t_tbl', 'id'), max(id)) FROM tbl;
2 rows affected
setval
2
 hidden batch(es)


INSERT INTO t_tbl DEFAULT VALUES; TABLE t_tbl;
1 rows affected
id foo
1 bar
2 bar1
3 bar
 hidden batch(es)


INSERT INTO t_tbl (foo) VALUES ('bar2'); -- would violate the copied (!) CHECK constraint
ERROR: new row for relation "t_tbl" violates check constraint "foo_bar" DETAIL: Failing row contains (4, bar2).
 hidden batch(es)