i have this file.txt that has a bunch of entries in it. i want to import these stuff into my db/table in Postgre.
the command for this would be:
copy my_table from 'some path';
now after execution i get an error like "you need a superuser access to use the copy command" or something similar -can't remember the exact error... i am logged in as the db admin.
but anyway how would i get around this?
thnx if u help
