944,052 Members | Top Members by Rank

Web Development > Databases > Database Design > Postgres ownership rules?
Ad:
Permalink
Sep 27th, 2006
0

Postgres ownership rules?

Expand Post »
Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me.

Thanks in advance,
-EnderX
Similar Threads
Reputation Points: 483
Solved Threads: 1
Posting Shark
EnderX is offline Offline
999 posts
since Aug 2006
Permalink
Sep 28th, 2006
0

Re: Postgres ownership rules?

Click to Expand / Collapse  Quote originally posted by EnderX ...
Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me.

Thanks in advance,
-EnderX 
ALTER TABLE vw_my_view OWNER TO pty;
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Slony Setup?
Next Thread in Database Design Forum Timeline: database connectivity





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC