Re: Fwd: pgadmin doesn't see tables?
От | David G. Johnston |
---|---|
Тема | Re: Fwd: pgadmin doesn't see tables? |
Дата | |
Msg-id | CAKFQuwY_kkJeGB1P4jt04NcAuPOH8ZuZuGGSn4EmiHR5jfg5VQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Fwd: pgadmin doesn't see tables? (Jim McNamara <thirdshiftcoder@gmail.com>) |
Ответы |
Re: Fwd: pgadmin doesn't see tables?
|
Список | pgsql-novice |
hi -in schema public my tables aren't listed pgadmin III.here is some diagnostic info.postgres=# alter table employee set schema public;ERROR: table employee is already in schema "public"postgres=# \dtList of relationsSchema | Name | Type | Owner--------+----------+-------+---------public | employee | table | blasterpublic | phone | table | blasterpostgres=# select * from employee;id | fname | lname----+-------+-------(0 rows)How come pgadmin can't see my table but the command linetools can see the table?thx. for any assistance - jim
This is likely to be operator error. Given you've shown zero data regarding pgAdminIII it is impossible to reasonably diagnose further.
David J.
В списке pgsql-novice по дате отправления: