This video shows how to load and scrub data from postgresql using sql commands in text files using the i psql command (execute commands from file)

Original source