@postgresql.org
Subject: [GENERAL] load sql from the file in postgresql
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 tab
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 t
>
> \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.
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company
Email: raghav
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 tri
