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