Re: regarding running a script in psql

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(dot)sivakiran(at)gmail(dot)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
>
>
>
>
>