Re: User tables

[Bricklen Anderson <banderson@xxxxxxxxxxxx>]

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