Search Postgresql Archives

Why can't I see the definition of my relations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux