COPY weather FROM '/home/user/weather.txt'; is not working it requires additional commands for me.
And your point is? The table has to have already been created and the file path needs to be modified to your personal circumstance. What is it exactly that you want to have changed?