> > 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 * from pg_tables where tableowner='green';
or from inside psql:
\z