Dear Sirs:
Postgresql was installed normally from source code in Ubuntu Hardy Heron
with standard configuration.
But I receive a message "Permission denied" when trying to run a .sql script
to create tables
in a already created database. The script is located in /usr/local/pgsql
Any suggestions?
Session example:
root(at)tikal:/home/pakal# su - postgres
No directory, logging in with HOME=/
$ /usr/local/pgsql/bin/psql -U neil -d bpsimple
psql (8.4.4)
Type "help" for help.
bpsimple=#
bpsimple=# \i /usr/local/pgsql/create_tables-bpsimple.sql
/usr/local/pgsql/create_tables-bpsimple.sql: Permission denied