| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, Sukuchha Shrestha <sukuchha(at)yahoo(dot)de> |
| Subject: | Re: load sql from the file in postgresql |
| Date: | 2011-04-29 13:32:44 |
| Message-ID: | 201104290632.44991.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phoenix Kiula | 2011-04-29 14:03:06 | Re: NULL saves disk space? |
| Previous Message | Sukuchha Shrestha | 2011-04-29 13:31:50 | Connecting matlab with postgresql |