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
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 |