hello group, I just started to use postgresql and i want to import data using copy command in a loop.
Here is what i did ! 1) following content with name loaddata.sql. \copy table from 'C:\psql\x.txt'; \copy table from 'C:\psql\y.txt'; 2) My loaddata.sql is located in C:\psql\ therefore i tried to call the loaddata.sql in psql like \i C:\psql\loaddata.sql But it says " C:: Permission denied" What is a problem ? Please guide me ! Is there any better way to call copy commad in a loop with varying filename! regards Sukuchha
