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

access information_schema

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 (view raw or flat)
Thread:
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?

Responses

pgsql-novice by date

Next:From: ahermosiDate: 2004-04-24 14:20:16
Subject: Problem with pgsql with fedora core 1
Previous:From: Josh BerkusDate: 2004-04-23 19:44:46
Subject: Re: Transaction speed

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