Re: No Relations Found Error - Mailing list pgsql-general

From Carlos Mennens
Subject Re: No Relations Found Error
Date
Msg-id AANLkTi=xeF+aiRfBRA7eDxLRCd2tX2f0P3uwr11vw0Mp@mail.gmail.com
Whole thread Raw
In response to No Relations Found Error  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: No Relations Found Error  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> Are the tables in a schema other than "public"? Enter "\dn" at the psql
> prompt to see what schemas are there.

Perhaps not. I wasn't aware of that. When I created the database
before I created and tables, I used the following command:

"createlang plpgsql wiki"

Could that be why I don't see them?

wiki=# \dn
        List of schemas
        Name        |  Owner
--------------------+----------
 information_schema | postgres
 mediawiki          | wiki
 pg_catalog         | postgres
 pg_toast           | postgres
 pg_toast_temp_1    | postgres
 public             | postgres
(6 rows)

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: No Relations Found Error
Next
From: Raymond O'Donnell
Date:
Subject: Re: No Relations Found Error