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. 1579847 fiddles created (21380 in the last week).

CREATE TABLE t (t text);
 hidden batch(es)


INSERT INTO t VALUES ('foo'), ('bar');
2 rows affected
 hidden batch(es)


ALTER TABLE t ADD COLUMN ogc_fid int GENERATED BY DEFAULT AS IDENTITY;
 hidden batch(es)


TABLE t;
t ogc_fid
foo 1
bar 2
 hidden batch(es)