Re: Fwd: pgadmin doesn't see tables? - Mailing list 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=# \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