regarding running a script in psql
От | siva kiran balijepalli |
---|---|
Тема | regarding running a script in psql |
Дата | |
Msg-id | AANLkTikrdLh6QprBnfEh1=WFZdAyzj=dz+WO01cBwGh2@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: regarding running a script in psql
|
Список | 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
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
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 по дате отправления: