Skip site navigation (1) Skip section navigation (2)

regarding running a script in psql

From: siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: regarding running a script in psql
Date: 2011-02-21 11:28:30
Message-ID: AANLkTikrdLh6QprBnfEh1=WFZdAyzj=dz+WO01cBwGh2@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: java4devDate: 2011-02-22 17:24:09
Subject: simple test code
Previous:From: LewDate: 2011-02-21 00:40:31
Subject: Re: Combining queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group