pgadmin doesn't list my postgresql tables
T
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
|