Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Sosinski
Subject Seeing tables with the same name on different schemas
Date
Msg-id 2433849924454530BB2C3755F1A4526B@ticketevolution.com
Whole thread Raw
Responses Re: Seeing tables with the same name on different schemas
List pgsql-general
Tree view
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: Andres Freund
Date:
Subject: Re: Need help in reclaiming disk space by deleting the selected records
Next
From: raghavendra.rao@enterprisedb.com
Date:
Subject: Re: Seeing tables with the same name on different schemas