From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: No Relations Found Error |
Date: | 2010-09-30 20:11:37 |
Message-ID: | 4CA4EEF9.2000100@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 30/09/2010 20:59, Carlos Mennens wrote:
> On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell<rod(at)iol(dot)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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Bartolini | 2010-09-30 20:15:53 | Re: [9.0] hot standby plus streaming replication |
Previous Message | Carlos Mennens | 2010-09-30 19:59:04 | Re: No Relations Found Error |