Why can't I see the definition of my relations - Mailing list pgsql-general

From Andrew Falanga
Subject Why can't I see the definition of my relations
Date
Msg-id 5e1d829c-5e8e-4522-93d1-f5a1ffeabad6@x1g2000prc.googlegroups.com
Whole thread Raw
Responses Re: Why can't I see the definition of my relations  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Hi,

I just finished defining a couple of tables with PgAdmin III and I'm
seeing something peculiar.  I'm not sure what the problem is.  When I
connect to the DB using psql and do "\d <table>" I get an error saying
that there's not relations by that name.  What?  When I do, "\d" I see
the tables listed.  Here's a sample of the output:

cgems=# \d
        List of relations
 Schema |  Name   | Type  | Owner
--------+---------+-------+-------
 public | Mineral | table | cgems
 public | Stone   | table | cgems
(2 rows)


cgems=# \d Stone
Did not find any relation named "Stone".

I'm guessing that it has something to do with permissions, but I'm
connecting using psql using the same UID that made the DB and the
tables.  If I connect to the DB using the UID of the table owner, I
get the same response.

Thanks for any help,
Andy

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: No PL/PHP ? Any reason?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Why can't I see the definition of my relations