On Tue, 2003-10-21 at 21:24, Christopher Kings-Lynne wrote:The problem about information_schema is that it's restricted to show objects of the owner only. This is by spec, but will prevent us from seeing all we need.
There is always the biggest evil of all... Putting SHOW / DESCRIBE /All that means for phpPgAdmin and pgAdmin is that we'll have to support 5 different queries :P
HELP commands into the backend itself. I'm sure the pgAdmin group likes
that idea (they're probably tired of maintaining 4 different versions of
queries for getting a list of tables). Any solution to make psql
backward or forward compatible should go an additional step to assist
other frontends as well.
Yes, but I would hope it stops at 5, and over the next 3 years you don't have 10 different query forms.
We could use information_schema...
Nay... I would expect a PostgreSQL specific information_schema to get
just as much mucking around as the system tables, which means you are
still maintaining a set of queries per release.
This might get better if we get rules.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
