SQL

insert postgres

INSERT INTO films (code, title, did, date_prod, kind)
    VALUES ('T_601', 'Yojimbo', 106, '1961-06-16', 'Drama');

POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE

##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 *

insert into postgres

INSERT INTO table_name VALUES (
  column_one_value, column_two_value, column_N_value);
  
INSERT INTO table_name (column_x, column_y, column_z)
VALUES (column_x_value, column_y_value, column_z_value);

insert to postgres table

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);

postgres insert into table

INSERT INTO table_name(column1, column2, …)
VALUES (value1, value2, …);
Code language: SQL (Structured Query Language) (sql)

Postgres insert

INSERT INTO links (url, name)
VALUES('https://www.postgresqltutorial.com','PostgreSQL Tutorial');
Code language: SQL (Structured Query Language) (sql)

postgresql, Rows, INSERT INTO

            
                
            
         INSERT INTO table_name(column1, column2, …)
VALUES (value1, value2, …)
RETURNING *;Code language: SQL (Structured Query Language) (sql)