Re: No Relations Found Error

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: No Relations Found Error
Date: 2010-09-30 19:33:44
Message-ID: AANLkTi=xeF+aiRfBRA7eDxLRCd2tX2f0P3uwr11vw0Mp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnell <rod(at)iol(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-09-30 19:43:11 Re: No Relations Found Error
Previous Message Carlos Mennens 2010-09-30 19:24:31 No Relations Found Error