[GENERAL] User tables

[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