Why can't I see the definition of my relations

From: Andrew Falanga <af300wsm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why can't I see the definition of my relations
Date: 2010-07-13 04:10:19
Message-ID: 5e1d829c-5e8e-4522-93d1-f5a1ffeabad6@x1g2000prc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-07-13 04:51:08 Re: No PL/PHP ? Any reason?
Previous Message Craig Ringer 2010-07-13 04:09:03 Re: \COPY ... CSV with hex escapes