Using Postgres with Rails


Hi - i was using sqLite as standard development tool but found that when pushing to production (PG on Heroku) I would find issues in migrations as sqlite was more forgiving than PG and also complex SQL queries specifically collections required different clauses etc

so firstly is there a way to make SQLite to respond as PG would


what would be the procudeure for using PG as my development database as well ?

I tried just altering my gem file and looked in my ENV but cant see where its specified


Found this…