Re: Need help extripating plpgsql

Adrian Klaver <adrian.klaver@gmail.com> wrote:=0A=0A> At this point I am no=
t sure how to do this with out creating role=0A> that has superuser privile=
ges.=0A=0ASomething like this?:=0A=0A-- Set up the template using database =
superuser.=0Acreate database template2;=0A\c template2=0Adrop extension plp=
gsql;=0Avacuum freeze analyze;=0A\c postgres=0Aupdate pg_database set datis=
template =3D true=0A=A0 where datname =3D 'template2';=0Acheckpoint;=0A=0A-=
- Create a user who can own the database and plpgsql.=0Acreate user bob wit=
h createdb;=0Aset role bob;=0Acreate database bob template template2;=0A\c =
bob=0Acreate extension plpgsql;=0A=0A--=0AKevin Grittner=0AEnterpriseDB: ht=
tp://www.enterprisedb.com=0AThe Enterprise PostgreSQL Company