harish2704/batch-insert-with-query-param.sql

Created October 13, 2023 07:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/harish2704/5b598ac571006f1cbbb944ba72e948d4.js"></script>
Save harish2704/5b598ac571006f1cbbb944ba72e948d4 to your computer and use it in GitHub Desktop.

Download ZIP

pass data as query parameter while using SQL insert into ( batch mode ) statement

Raw

batch-insert-with-query-param.sql

+INSERT INTO my_table (col_a, col_b)
+    (SELECT col_a,
+             col_b
+        FROM json_populate_recordset(NULL::my_table, ?)
+    )
+-- Here query parameter should be a json collection ( array of objects ) which matches with column names of my_table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment