Re: Strange "missing tables" problem

Hello,

Wojtek a écrit :
>> 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

Yes but why the import.customers table doesn't appear, then ?

>> # \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'

Yes that's correct

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

Yes, in fact they are two different tables...

Denis