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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
