Diego Schulz wrote: > > Sorry, forgot to say that I SET search_path acordinlly to see relations > > from both schemas. But whan the table has the same name I only get the one > > from the first schema in the search_path. > > > > > I can confirm the behaviour you described. Yes, \dt was designed that way, and *.name is the proper way to show tables in all schemas. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
