On Wed, 2005-11-30 at 12:08, frank church wrote: > Hi guys, > > What is the command change database owner in PostgreSQL 7.4? > > I think the 'ALTER DATABASE foo OWNER TO blob;' is not implemented in 7.4 >
update pg_database set datdba=(select usesysid from pg_user where usename='newowner'); ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster