Create Postgresql Extension for Multiple Schema

Question

I Work with Postgresql 9.2 and I try to make Postgis 2.x extension for two schemas

My code is

create extension postgis schema public

it is working but I want to create extension for two schemas e.g public,second ...

Can anibody help me?

Specifying a schema while creating an extension indicates where you want the extension's objects created, not for which schemas the extension is available - it's available for the whole DB. — Milen A. Radev
– Milen A. Radev, Commented Oct 26, 2013 at 12:57
There is no db option postgresql.org/docs/9.1/static/sql-createextension.html — javagc
– javagc, Commented Oct 26, 2013 at 14:41

corvinusz · Accepted Answer · 2013-10-26 17:22:19Z

2

According to http://www.postgresql.org/docs/9.2/static/sql-createextension.html

Extension itself is not considered to be within any schema, but it can save objects within specified schema. Specifying more than one schema is an unrealizable.

answered Oct 26, 2013 at 17:22

corvinusz

5843 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create Postgresql Extension for Multiple Schema

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related