On 30/09/2010 20:59, Carlos Mennens wrote:
On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell<rod@xxxxxx> 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@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
