Re: Seeing tables with the same name on different schemas

raghavendra.rao@xxxxxxxxxxxxxxxx · Fri, 14 Sep 2012 12:59:02 +0000

How about using this way ?

\dt *.*

Or 

\dt schemaname.*

--RaghavSent from my BlackBerry® smartphone from !DEA
From:  Robert Sosinski <rsosinski@xxxxxxxxxxxxxxxxxxx>
Sender:  pgsql-general-owner@xxxxxxxxxxxxxx
Date: Fri, 14 Sep 2012 08:47:54 -0400
To: <pgsql-general@xxxxxxxxxxxxxx>
Subject: [GENERAL] Seeing tables with the same name on different schemas

                Hey Everyone,

Question, I have multiple schemas on a database, and these schemas sometimes have the tables of the same name.  However, when I do \d to see what tables I have, I only see the first table (based on the order of the search path), but no the other tables that have the same name on different schemas.

Is there a way to see all tables across all schemas?

Thanks,

-- 
Robert Sosinski