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?  ("Day, David" <dday@redcom.com>)
Список pgsql-novice
On Tue, Jun 14, 2016 at 1:25 PM, Jim McNamara <thirdshiftcoder@gmail.com> wrote:

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=# \dt
          List of relations
 Schema |   Name   | Type  |  Owner  
--------+----------+-------+---------
 public | employee | table | blaster
 public | phone    | table | blaster

postgres=# select * from employee;
 id | fname | lname 
----+-------+-------
(0 rows)

How come pgadmin can't see my table but the command line
tools 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 по дате отправления:

Предыдущее
От: Jim McNamara
Дата:
Сообщение: Fwd: pgadmin doesn't see tables?
Следующее
От: "Day, David"
Дата:
Сообщение: Re: Fwd: pgadmin doesn't see tables?