| 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 |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-04-27 17:38:40 | Re: Field with character varying (255) |
| Previous Message | Joe Conway | 2004-04-26 17:31:26 | Re: comma separated value splitting |