Re: Missing tables in tree

> -----Original Message-----
> From: Howard Hansen [mailto:howardh@halfmagic.com]
> Sent: 27 January 2004 16:00
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Missing tables in tree
>
> Love pgAdmin, but I've run into a problem since moving my
> server from my internal network to one hanging off of the
> Internet directly.  On the client, I'm running pgAdmin 1.6.0
> with psqlODBC 7.3.100.  Server-side, it's PostgreSQL 7.3.4 on
> a Debian Woody box.
>
> Previously, I would connect to the server, see a list of the
> databases, then when I clicked on one and expanded it in the
> tree, I would see all manner of cool things including Tables.
>  No longer.  I see only Casts, Languages, and Schemas.  The
> logged-in user is defined as:
>
> CREATE USER username WITH SYSID 103 CREATEDB CREATEUSER VALID UNTIL
> '2006-01-17 00:00:00';
>
> I've tried about a dozen Google queries, but I haven't found
> the magic one yet.
>
> I don't mean to complain, but Casts, Languages, and Schemas
> are not nearly as useful to me as -- say -- Tables, Indexes,
> and Sequences.  Any and all help, pointers, or even sympathy
> will be greatly appreciated.
>
> Please cc me on replies, since I'm not on the list.  Thanks!

Expand schemas - in PostgreSQL 7.3+ tables etc. all live in a schema.

Regards, Dave.