Quick Links

Changing ownership of objects

From:	"Peter Darley" <pdarley(at)kinesis-cem(dot)com>
To:	"Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject:	Changing ownership of objects
Date:	2002-05-28 21:36:39
Message-ID:	NNEAICKPNOGDBHNCEDCPEEDBCJAA.pdarley@kinesis-cem.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-novice

Friends,
When I was young and foolish and setting up my DB initially I ended up with
the objects in my DB owned by random users. I'd like to write a script to
change the user for all objects to be the same, but I don't see any way to
change the ownership of sequences. Any ideas?
Thanks,
Peter Darley

Responses

Re: Changing ownership of objects at 2002-05-28 22:47:59 from Tom Lane
Re: Changing ownership of objects at 2002-05-28 23:06:36 from Joshua b. Jore
Re: Changing ownership of objects at 2002-05-29 21:50:50 from Manuel Sugawara

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2002-05-28 22:47:59	Re: Changing ownership of objects
Previous Message	Joel Burton	2002-05-28 21:12:53	Re: Database Rights

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Tom Lane	2002-05-28 22:47:59	Re: Changing ownership of objects
Previous Message	Tom Lane	2002-05-28 19:22:51	Re: remnants of deleted table causing problems