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

From Raymond O'Donnell
Subject Re: No Relations Found Error
Date
Msg-id 4CA4EEF9.2000100@iol.ie
Whole thread Raw
In response to Re: No Relations Found Error  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
On 30/09/2010 20:59, Carlos Mennens wrote:
> On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell<rod@iol.ie>  wrote:
>> On 30/09/2010 20:43, Raymond O'Donnell wrote:
>>
>>> http://www.postgresql.org/docs/9.0/static/ddl-schemas.html
>>>
>>> Have a look at section 5.3.7 on the search path in particular, as this
>>
>> Whoops, sorry - that's 5.7.3.
>
> Thank you. I am reading the schema section you provided and it gives a
> dry sense of what it does however I don't understand who I can access
> the tables for the schema 'mediawiki'?

You can use a pattern in your \d commands, thus:

    To see tables:     \dt mediawiki.*
    To see sequences:  \ds mediawiki.*
    etc....

You can also set the search path - see that bit in the docs.

\? is your friend here also.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Re: No Relations Found Error
Next
From: Gabriele Bartolini
Date:
Subject: Re: [9.0] hot standby plus streaming replication