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

From raghu ram
Subject Re: regarding running a script in psql
Date
Msg-id AANLkTimi5SQxCqzfArGPq0TZ8LQzgEd=UCrSDS0+ehvd@mail.gmail.com
Whole thread Raw
In response to regarding running a script in psql  (siva kiran balijepalli <b.sivakiran@gmail.com>)
List pgsql-novice
Hi Siva,

Could you please try to run script from PSQL prompt as follows:

psql=# \i 'c:/Program Files/PostgresPlus/9.0SS/share/contrib/isn.sql'

--Raghu

On Mon, Feb 21, 2011 at 4:58 PM, siva kiran balijepalli <b.sivakiran@gmail.com> wrote:
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: Manlin Vee
Date:
Subject: Re: Failure to Call a Nested Function
Next
From: Le Fromager
Date:
Subject: Re: Do checkpoints flush all data from shared buffers ?