Thread: User tables

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

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 try
select * from pg_tables where tableowner='green';

> > 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