I successfully created my first db, a table and some data with psql
7.3.6. However, I can't access the information_schema. In psql I tried
SELECT * FROM information_schema.columns
SELECT * FROM information_schema.tables
but I get the error message that information_schema wouln't exist.
* Do I have to activate them?
* I don't think it's because of my permissions.
* I use psql 7.3.6.
* How could I list all availabel schemas?
* How do I access information_schema stuff?
pgsql-novice by date
|Next:||From: ahermosi||Date: 2004-04-24 14:20:16|
|Subject: Problem with pgsql with fedora core 1|
|Previous:||From: Josh Berkus||Date: 2004-04-23 19:44:46|
|Subject: Re: Transaction speed|