From: | Antti Haapala <antti(dot)haapala(at)iki(dot)fi> |
---|---|
To: | Rod Taylor <rbt(at)rbt(dot)ca> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 Wishlist |
Date: | 2003-01-22 15:46:33 |
Message-ID: | Pine.LNX.4.44.0301221718270.2866-100000@lastu1.oulu.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > SHOW
> > ----
> >
> > I think 7.4 could and really should implement SHOW command similar to
> > MySQL. Listing tables/foreign keys/views and so isn't just psql problem,
>
> Actually, in 7.4 I'd tell them to:
>
> select * from information_schema.tables;
>
> This is a far more portable method.
Yep. You know it was just a draft which wasn't actually meant to be
sent...
I think the contents of that information schema could and should be user
modifiable views...
I needed to administer one of my dbs on 7.3 from another computer with
psql 7.2.3 -- for the computer had PG 7.2.3 running, and \d on for example
views failed gratuituosly with error "relation pg_relcheck not found". Of
course the dumps, sql commands and tsv data etc. I needed were only on
that 7.2.3 machine...
Many interfaces need to enumerate tables & databases etc. I'm not
interested in having different versions of for example DBD::Pg... one, the
most up-to-date, version should do the job. Against whatever version of
postmaster I want to use it.
So maybe backwards compatibility could be introduced also (older clients &
applications against newer DBMS) by having different information schemas
for different client versions... don't know, how it should be actually
done. Maybe there would be schemas "info_compat_74", "info_compat_75"
and "information_schema_80" in PostgreSQL 8.0 :P and "information_schema"
could be alias to most appropriate of these, depending on client version
:) (dunno).
--
Antti Haapala
+358 50 369 3535
ICQ: #177673735
From | Date | Subject | |
---|---|---|---|
Next Message | Didier Moens | 2003-01-22 16:04:59 | Re: Foreign key wierdness |
Previous Message | Curtis Faith | 2003-01-22 15:34:58 | Re: Windows Build System was: Win32 port patches submitted |