subject:"\[GENERAL\] User tables"

Re: [GENERAL] User tables

2006-03-04 Thread chris smith

> > Suppose there 3 users red, green, blue. How can the user green know what > > tables he has created?! > > From psql command line \dt lists every table in the DB!!! > > > > Thanks in advance. > > > > Hrishi > If you mean that the owner of the table(s) is the user "green", then try > select * fro

Re: [GENERAL] User tables

2006-03-03 Thread Bricklen Anderson

Hrishikesh Deshmukh wrote: Hello All, Suppose there 3 users red, green, blue. How can the user green know what tables he has created?! From psql command line \dt lists every table in the DB!!! Thanks in advance. Hrishi If you mean that the owner of the table(s) is the user "green", then tr

[GENERAL] User tables

2006-03-03 Thread Hrishikesh Deshmukh

Hello All,Suppose there 3 users red, green, blue. How can the user green know what tables he has created?!From psql command line \dt lists every table in the DB!!!Thanks in advance.Hrishi