test=# \dt aa List of relations Name | Type | Owner ------+-------+------- aa | table | pippo
test=# drop user PIPPO; DROP USER
test=# \dt aa List of relations Name | Type | Owner ------+-------+------- aa | table |
Hope that helps. ~R
ps. I had to change the syntax of your alter table statement to "alter table aa owner to pippo;" for it to work.
frank_lupo wrote:
I have create user PIPPO: CREATE USER PIPPO;
I have create a table:
create table aa (id int4); Change owner of table to user PIPPO. alter table aa owner pippo;
I drop user PIPPO. Who is the owner of the table?
Thanks.
Bye !! Frank Lupo (Wolf) !!
/\_ _/\ \ o o / --ooo-----ooo---
-- Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor: Usi ancora fax e carta? Allora sei preistorico! Oggi i fax li ricevi direttamente sul computer con il nuovo EmailFax IN Clicca e scopri i vantaggi Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1568&d=10-11
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
