I have a sequence of insert statements which I want to run on a Postgres database. It looks something like this -
INSERT INTO test_admin.test_admins (id, "name", description, start_date, end_date) VALUES ( 3, 'admin', NULL, TO_TIMESTAMP ('10/01/2015 00:00:00.00 -0500', 'MM/DD/YYYY fmHH24fm:MI:SS.FF Z'),
Due to the extra spaces preceding each line, neither pgadmin 3, nor the postgres console would accept this query and give syntax errors. What is the best way to remove these?