Re: Need help extripating plpgsql

Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:

> At this point I am not sure how to do this with out creating role
> that has superuser privileges.

Something like this?:

-- Set up the template using database superuser.
create database template2;
\c template2
drop extension plpgsql;
vacuum freeze analyze;
\c postgres
update pg_database set datistemplate = true
  where datname = 'template2';
checkpoint;

-- Create a user who can own the database and plpgsql.
create user bob with createdb;
set role bob;
create database bob template template2;
\c bob
create extension plpgsql;

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company