Create schema in Heroku Postgresql DB

Question

I'm trying to create a schema in heroku DB. I tried using heroku pg:psql --app app_name DATABASE < schema.sql

schema.sql:

CREATE SCHEMA schema_name AUTHORIZATION user_name;

But my program still says that schema_name doesn't exist. Maybe I'm missing something

Antonio · Accepted Answer · 2015-06-02 16:50:32Z

6

I found the problem! I was using Windows console but heroku pg:psql --app app_name DATABASE < schema.sql command didn't work here. I used MINGWN32 console and the following command: cat schema.sql | heroku pg:psql --app app_name and everything worked!

answered Jun 2, 2015 at 16:50

Antonio

11.5k6 gold badges36 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create schema in Heroku Postgresql DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related