Re: R: change owner on a table

here's what i did (background methodology for future reference):

1. first i started psql -E to have it reveal the backend queries

This is really a useful way to discover where/how information is
stored/related in postgres via the console commands

2. I issued a \dt on the command to get the list of tables

team=> \dt
QUERY: SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user WHERE usesysid = relowner and ( relkind = 'r') and relname !~ '^pg_' ORDER BY relname

you'll see that it joins on usesysid = relowner, so all you need to do is
determine the usesysid of the new owner you want to own the table

3. select usesysid from pg_user where usename = 'newowner';

4. update pg_class set relowner = USESYSID WHERE relname =
'tableToUpdate';

where USESYID is the user id returned from above query in step 3

5. pat yourself on the back for being clever (no one else in your org will ;)

-duck

> On Thu, 25 Jan 2001, Marco DI NARDO wrote:
>
> > I've a problem is quite the same.
> > i've got a table that was created by one user in a database (me), and I want to
> > grant to other postgres user the right to view or update this table.
> > Marco
> > m(dot)dinardo(at)gruppodigito(dot)com
>
> I thought this is what the "grant" command is.
> I don't recall the exact syntax but it is something like:
> grant all to <user> on <table>;
>

-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------