'Cannot write to Postgres database in Heroku

I am trying to manually run a SQL script to create some tables and insert some data on my recently created Heroku instance, database is Postgres, when running I get the error

ERROR:  permission denied to create database

To connect I am running the following which is all taken from my DATABASE_URL variable.

heroku run psql -h myhost -p port -d database -U user -f ./sql/daily_fixtures.sql

How can I deal with this?

postgresqlheroku


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions