Postgres Pro
Downloads
Home   >   mailing lists

Fwd: pgadmin doesn't see tables? - Mailing list pgsql-novice

From Jim McNamara
Subject Fwd: pgadmin doesn't see tables?
Date
Msg-id CAC8eACga9pOY9YnLDCqjkEF1XSouM=H50RLRO+VTynGs3TLr+A@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: pgadmin doesn't see tables?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view

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

    pgsql-novice by date:

    Previous
    From: Tom Lane
    Date:
    Subject: Re: Collation
    Next
    From: "David G. Johnston"
    Date:
    Subject: Re: Fwd: pgadmin doesn't see tables?