Re: Fwd: pgadmin doesn't see tables?

 

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