postgres-dump-converter

Motivation

I create this script to help me convert a postgres dump form having multiple INSERT statements for one table to have one INSERT statements of more rows per each table. You can achieve the same result by using pg_dump with the following parameters: --inserts --row-per-insert=NNN (NNN = number of rows per INSERT)

Description

This script reads in a text file containing SQL INSERT INTO statements and converts them into a single multiple rows INSERT INTO statement for each table.

How it works

• The script reads in the text file and splits its contents into an array of lines.
• It iterates through the array of lines and checks if each line starts with the INSERT INTO keyword.
• If a line does start with the INSERT INTO keyword, it extracts the table name from the line and adds it to an object that holds the insert statements for each table.
• If a line does not start with the INSERT INTO keyword, it prints the line as is.
• When all lines have been processed, the script iterates through the keys in the object and creates a single multiple rows INSERT INTO statement for each table by joining the array of insert statements for the table with commas.

Example

Input:

INSERT INTO table1 (col1, col2) VALUES (1, 'a');
INSERT INTO table1 (col1, col2) VALUES (2, 'b');
INSERT INTO table2 (col1, col2) VALUES (3, 'c');

Output:

INSERT INTO table1 (col1, col2) VALUES (1, 'a'), (2, 'b');
INSERT INTO table2 (col1, col2) VALUES (3, 'c');

Usage

To use this script, replace the test/inputFile argument in the fs.readFile function with the path to your input file and run the script using Node.js.

node script.js > test/outputFile

Note

The script and the readme page was created using chat.openai.com