Search Postgresql Archives

Re: Strange "missing tables" problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux