Any one know how to install extensions to multiple databases in the same server ?
Thanks in advance Brian
From: Brian Trudal <dbrb2002-sql@yahoo.com> To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Sent: Monday, March 5, 2012 4:52 PM Subject: Single server multiple databases - extension
Hi
I have 2 databases running in a single server; and I installed extension 'hstore' to one database and it works fine. When I tried to use the same extension in another database, it gives an error saying 'extension does not exist'; nor it allow to install as it complains about its existence.
Any help ?
db1=# CREATE EXTENSION hstore; ERROR: type "hstore" already exists db1=# DROP EXTENSION hstore; ERROR: extension "hstore" does not exist db1=# create table foo(id hstore); ERROR: type "hstore" is only a shell LINE 1: create table foo(id hstore); ^
