No Relations Found Error
I created today a new database and user for my Wiki. Now I created
both the db user and actual db as 'carlos' even though the owner of
the db 'wiki' is a user named 'wiki'. My user 'carlos' is a superuser
however. So I then wanted to view and change some data but I keep
getting this error:
carlos@wiki]:~$ psql -d wiki
psql (8.4.4)
Type "help" for help.
wiki=# \d
No relations found.
Anyone know what I am doing wrong?
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)
Import Notes
Reply to msg id not found: 4CA4E57F.7020808@iol.ie
On 30/09/2010 20:33, Carlos Mennens wrote:
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?
No, not at all - that just installs the pl/pgsql language in the
database. However....
wiki=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
mediawiki | wiki
...it looks as if MediaWiki has created a schema for itself during the
installation procedure, and that's where the tables and stuff are.
If you're not familiar with schemas, here's the section of the docs you
need to read:
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
will make your life much easier when using psql. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
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.
Ray..
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
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'?
wiki=# \dn mediawiki
List of schemas
Name | Owner
-----------+-------
mediawiki | wiki
(1 row)
I can see the schema name and owner but what if I want to look inside?
Normally I would use the \d to view all the table info in the
connected database but now I can't do this in my 'wiki' database for
whatever reason. Perhaps because it was not created in the 'public'
schema rather than it's own custom schema.
wiki=# \c webmail
psql (8.4.4)
You are now connected to database "webmail".
webmail=# \d
List of relations
Schema | Name | Type | Owner
--------+---------------------+----------+---------
public | cache | table | webmail
public | cache_ids | sequence | webmail
public | contact_ids | sequence | webmail
public | contactgroupmembers | table | webmail
public | contactgroups | table | webmail
public | contactgroups_ids | sequence | webmail
public | contacts | table | webmail
public | identities | table | webmail
public | identity_ids | sequence | webmail
public | message_ids | sequence | webmail
public | messages | table | webmail
public | session | table | webmail
public | user_ids | sequence | webmail
public | users | table | webmail
(14 rows)
How would I achieve this on my 'wiki' database?
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