Re: Strange "missing tables" problem - Mailing list pgsql-general

From Wojtek
Subject Re: Strange "missing tables" problem
Date
Msg-id 4A91443B.7040106@twine.pl
Whole thread Raw
In response to Re: Strange "missing tables" problem  (Denis BUCHER <dbucherml@hsolutions.ch>)
Responses Re: Strange "missing tables" problem
List pgsql-general
Denis BUCHER wrote:
> Hello,
>
> It's even more strange :
>
why, looks logical to me :)
> # \dt customers
>            Liste des relations
>  Schéma |   Nom   | Type  | Propriétaire
> --------+---------+-------+--------------
>  rma    | customers | table | postgres
> (1 ligne)
>
you have 1 'customers' table in 'rma' schema and (my guess) currently
you're connected as main user for this schema
> # \dt import.customers
>                Liste des relations
>      Schéma      |   Nom   | Type  | Propriétaire
> -----------------+---------+-------+--------------
>  import          | customers | table | postgres
> (1 ligne)
>
>
you have 1 'customers' table in 'import' schema
> # \dt *.customers
>                Liste des relations
>      Schéma      |   Nom   | Type  | Propriétaire
> -----------------+---------+-------+--------------
>  import          | customers | table | postgres
>  rma             | customers | table | postgres
> (2 lignes)
>
>
you have two tables 'customers', one in schema 'import', the other one
in schema 'rma'

I assume you want to keep two copies of this table, right?

foo

pgsql-general by date:

Previous
From: "Bill Bartlett"
Date:
Subject: Re: Strange "missing tables" problem
Next
From: Denis BUCHER
Date:
Subject: Re: Strange "missing tables" problem