How do I make a script that properly introduces hstore in both 9.0 and 9.1?
- by Igor Zinov'yev
I am trying to introduce the hstore type into the database of a project I'm developing. But the problem is that I have a slightly newer version of the Postgres server installed on my development machine than there is on the production machine. While I can simply execute the CREATE EXTENSION command locally, this command is unavailable on the production machine.
Is there a way to create a script that will install hstore both on 9.1 and 9.0?