Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing tables with the same name on different schemas - Mailing list pgsql-general

From raghavendra.rao@enterprisedb.com
Subject Re: Seeing tables with the same name on different schemas
Date
Msg-id 986680767-1347627567-cardhu_decombobulator_blackberry.rim.net-528136949-@b27.c12.bise7.blackberry
Whole thread Raw
In response to Seeing tables with the same name on different schemas  (Robert Sosinski <rsosinski@ticketevolution.com>)
List pgsql-general
Tree view
How about using this way ?

\dt *.*

Or

\dt schemaname.*

--Raghav
Sent from my BlackBerry® smartphone from !DEA
From: Robert Sosinski <rsosinski@ticketevolution.com>
Sender: pgsql-general-owner@postgresql.org
Date: Fri, 14 Sep 2012 08:47:54 -0400
To: <pgsql-general@postgresql.org>
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

pgsql-general by date:

Previous
From: Robert Sosinski
Date:
Subject: Seeing tables with the same name on different schemas
Next
From: Yvon Thoraval
Date:
Subject: SQLSTATE[08006] [7] server closed the connection unexpectedly