Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

drop table if exists my_table;
create table my_table (id int primary key, col1 text, col2 text);

DROP TABLE

CREATE TABLE

insert into my_table
select id, 'alfa', 'beta'
from generate_series(1,4) as id;

INSERT 0 4

select *
from my_table;

id
col1
col2

1
alfa
beta

2
alfa
beta

3
alfa
beta

4
alfa
beta

SELECT 4