PSQL script to read files from folder

 -- Assuming you have a table named file_content with a text column named content
CREATE TABLE IF NOT EXISTS file_content (
    content TEXT
);


CREATE TEMPORARY TABLE temp_file_content (temp_content TEXT);


COPY temp_file_content FROM '/var/lib/postgresql/14/main/admin.txt' WITH DELIMITER E'\x01' CSV;


INSERT INTO file_content
SELECT unnest(string_to_array(temp_content, E'\n'))
FROM temp_file_content;
select * from temp_file_content;


-- Drop the temporary table
DROP TABLE temp_file_content;