On 10/5/2015 8:47 AM, wjarl(at)hotmail(dot)com wrote:
> I have 1 database named general and 2 schemas crm and erp. When i create
> extension "uuid-ossp" i 'need' to specify the schema example erp; create
> extension "uuid-ossp" schema erp, however when i try to use it on crm i
> can't. if i try to create extension "uuid-ossp" schema crm, it reads
> extension "uuid-ossp" already exists.
> Any suggestions?
put the extension in the public schema so its available to all schemas
as long as you leave public in the search_path
--
john r pierce, recycling bits in santa cruz