On Sat, 24 Apr 2004, f.kater wrote:
> 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 III||Date: 2004-04-27 17:38:40|
|Subject: Re: Field with character varying (255)|
|Previous:||From: Joe Conway||Date: 2004-04-26 17:31:26|
|Subject: Re: comma separated value splitting|