How about using this way ? \dt *.*
Or \dt schemaname.* --Raghav Sent from my BlackBerry® smartphone from !DEA -----Original Message----- From: Robert Sosinski <[email protected]> Sender: [email protected]: Fri, 14 Sep 2012 08:47:54 To: <[email protected]> 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
