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.dinardo@gruppodigito.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@backpack.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!"
-----------------------------------------------------------------------------