regarding running a script in psql - Mailing list pgsql-novice

From siva kiran balijepalli
Subject regarding running a script in psql
Date
Msg-id AANLkTikrdLh6QprBnfEh1=WFZdAyzj=dz+WO01cBwGh2@mail.gmail.com
Whole thread Raw
Responses Re: regarding running a script in psql
List pgsql-novice
Hi every one,
 
Pre Basic Question

Just starting with Postgres

My System – MS Vista

Installed Postgresql 8.4.2

Able to get into psql command tool and create a simple database, using direction from “Beginning Databases With Postgres”

Try to Run Sql script from a folder on C: that codes several Tables

bpsimple=# \i C:\Program Files\PostGreSql\create_tables-bpsimple.sql

Error
C:: Permission denied

tried also all the following
bpsimple=> \i 'D:\scripts.sql';
D:scripts.sql: No such file or directory
bpsimple=> \i 'D:\\scripts.sql';
D:/scripts.sql: No such file or directory
bpsimple=> \i 'D:/scripts.sql';
D:/scripts.sql: No such file or directory
bpsimple=> \i 'D://scripts.sql';
D:/scripts.sql: No such file or directory
bpsimple=> \i D://scripts.sql;
D:/scripts.sql: No such file or directory
bpsimple=> \i D:/scripts.sql;
D:/scripts.sql: No such file or directory
bpsimple=> \i D:\scripts.sql;
D:: Permission denied
bpsimple=> \i D:\\scripts.sql;
D:: Permission denied
 
 
please
guide me
 

 
 

pgsql-novice by date:

Previous
From: Lew
Date:
Subject: Re: Combining queries
Next
From: java4dev
Date:
Subject: simple test code