postgresql \i import sql file permission denied
postgresql \i import sql file permission denied in windows
postgres=# \i C:\app\orauser\person.sql
C:: Permission denied
Solution:
use ‘/’ instead of use ‘\’
postgres=# \i C:/app/orauser/person.sql
postgres=# \d
List of relations
Schema | Name | Type | Owner
——–+—————+———-+———-
public | person | table | postgres
public | person_id_seq | sequence | postgres
(2 rows)
postgres=# select count(*) from person;
count
1000
(1 row)
No comments yet
DBA 