How do I make a script that properly introduces hstore in both 9.0 and 9.1?

Posted by Igor Zinov'yev on Stack Overflow See other posts from Stack Overflow or by Igor Zinov'yev
Published on 2012-12-11T11:04:04Z Indexed on 2012/12/14 11:04 UTC
Read the original article Hit count: 309

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?

© Stack Overflow or respective owner

Related posts about postgresql-9.1

Related posts about ddl