My name is Mike Griffin and we are adding PostgreSQL support to our product, MyGeneration. MyGeneration pulls meta-data from DBMS systems to generate business objects and stored procedures and such.
We are using the .NET managed provider Npgsql.dll. We typically get meta data from OleDb providers and they provide good meta, however, there are none for PostgreSQL that support the meta data services, so we're hitting system tables. I'm very familiar with the INFORMATION SCHEMA views as Microsoft SQL server and other databases support them, as does PostgreSQL 7.4 and up, however, if we only support 7.4 and up we'll be losing out on most of the installed PostgreSQL user base. So now I'm writing monster queries against system tables, I mean monster queries. It's brutal. So here's my question: Can I take the INFORMATION SCHEMA views from 7.4 and install them in older versions of PostgreSQL, if so, how far back can they work? Mike Griffin MyGeneration Software http://www.mygenerationsoftware.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
