Postgres ownership rules?

Reply

Join Date: Aug 2006
Posts: 999
Reputation: EnderX is an unknown quantity at this point 
Solved Threads: 1
EnderX EnderX is offline Offline
Posting Shark

Postgres ownership rules?

 
0
  #1
Sep 27th, 2006
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
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 523
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Postgres ownership rules?

 
0
  #2
Sep 28th, 2006
Originally Posted by EnderX View 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
ALTER TABLE vw_my_view OWNER TO pty;
Note to self... pocket cup
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum


Views: 2195 | Replies: 1
Thread Tools Search this Thread



Tag cloud for Database Design
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC