Skip site navigation (1) Skip section navigation (2)

Re: access information_schema

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 (view raw or flat)
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.

In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2004-04-27 17:38:40
Subject: Re: Field with character varying (255)
Previous:From: Joe ConwayDate: 2004-04-26 17:31:26
Subject: Re: comma separated value splitting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group