On Friday, April 29, 2011 4:01:03 am Raghavendra wrote:
> > \i C:\psql\loaddata.sql
> >
> >
> > But it says " C:: Permission denied"
>
> Give the permission to postgres user on 'loaddata.sql' file. Right click
> and in properties give full access to postgres user.
Just to be clear this means the user you are logged in as when you do the \i
command, which may or may not be the user postgres. The rule is, COPY runs with
the permissions of the server and \copy with the permissions of the client.
>
> Best Regards,
> Raghavendra
--
Adrian Klaver
adrian.klaver@gmail.com