One other benefit of having more stuff in information_schema.* is that the stuff there is "easier" to look at and figure out what it is. With the view definitions that are provided to things like psql and pgAdmin when people look at an information_schema view, it provides them a way of figuring out where in the internal tables stuff is if they want to look for it. i.e. they can find a column in information_schema.constraint_column_usage and go "gee where is that in the real PostgreSQL tables"? Then look at the code that generates it and so on.
OK, so make a pg_columns system view.
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
