Re: Fwd: pgadmin doesn't see tables?

On Tue, Jun 14, 2016 at 1:25 PM, Jim McNamara <thirdshiftcoder(at)gmail(dot)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.
​