xxxxxxxxxx
##fetch data from other table with sub-query to insert it into another one
INSERT INTO PUBLIC."MyTable"(conversion_job_id, message, last_status)
VALUES (17, 'test', (SELECT status FROM PUBLIC."OtherTable" WHERE id=17))
RETURNING *
xxxxxxxxxx
insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;
xxxxxxxxxx
CREATE OR REPLACE FUNCTION function_copy() RETURNS TRIGGER AS
$BODY$
BEGIN
INSERT INTO
table2(id,name)
VALUES(new.id,new.name);
RETURN new;
END;
$BODY$
language plpgsql;
xxxxxxxxxx
CREATE TRIGGER trig_copy
AFTER INSERT ON table1
FOR EACH ROW
EXECUTE PROCEDURE function_copy();
xxxxxxxxxx
INSERT INTO holiday_calender (hcl_country,hcl_company,hcl_date,hcl_description,hcl_active) VALUES
(2,1,'2022-05-21 00:00:00','Holiday 1',1),
(2,1,'2022-05-22 00:00:00','Holiday 2',1),
(2,1,'2022-05-23 00:00:00','Holiday 3',1),
(2,1,'2022-05-25 00:00:00','Holiday 4',1),
(2,1,'2022-05-26 00:00:00','Holiday 5',1),
(2,1,'2022-05-28 00:00:00','Holiday 6',1);
xxxxxxxxxx
INSERT INTO table_name(column1, column2, …)
VALUES (value1, value2, …);
Code language: SQL (Structured Query Language) (sql)