Re: Views, views, views! (long)

Josh Berkus wrote:
> And, as an increasing number of 3rd-party tools support PostgreSQL (like
> Embarcadero) they need a simple comprehensible API for system objects -- more
> objects than are included in the information_schema.

There are only two choices: Creating a minimal subset tool, which will
rely on INFORMATION_SCHEMA (or a schema API as in ODBC) as standardized
by SQL specs, or making it specifically for every DBMS, whether using
some fancy views or not.

> A 3rd
> party proprietary vendor is not going to learn about OIDs,

Doing it seriously, it probably needs the internal DBMS object
identifiers (oid in the case of pgsql), to uniquely identify objects
even after a rename. Hiding the OIDs in schema views will reduce their
usability.

Regards,
Andreas