Fwd: pgadmin doesn't see tables?

From: Jim McNamara <thirdshiftcoder(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fwd: pgadmin doesn't see tables?
Date: 2016-06-14 17:25:51
Message-ID: CAC8eACga9pOY9YnLDCqjkEF1XSouM=H50RLRO+VTynGs3TLr+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

-
<https://us-mg5.mail.yahoo.com/neo/launch?.rand=0i68028vslidq#>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2016-06-14 19:17:58 Re: Fwd: pgadmin doesn't see tables?
Previous Message Tom Lane 2016-06-11 15:43:08 Re: Collation