Lists: | pgsql-novice |
---|
From: | f(dot)kater2(at)gmx(dot)net (f(dot)kater) |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | access information_schema |
Date: | 2004-04-24 10:02:12 |
Message-ID: | c74e9fd0.0404240202.19b0b90e@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
Hi,
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
queries like
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?
From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | "f(dot)kater" <f(dot)kater2(at)gmx(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: access information_schema |
Date: | 2004-04-26 18:58:55 |
Message-ID: | 20040426115827.R11044@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
On Sat, 24 Apr 2004, f.kater wrote:
> Hi,
>
> 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
> queries like
>
> 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?
IIRC, information_schema was added in 7.4.