User tables

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