Information Schema - Can the views be applied to older versions of PostgreSQL

From: mike(dot)griffin(at)mygenerationsoftware(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Information Schema - Can the views be applied to older versions of PostgreSQL
Date: 2004-06-11 15:26:10
Message-ID: 43495.168.215.73.114.1086967570.squirrel@168.215.73.114
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-06-11 15:26:38 Re: postgresql training course, please recommend
Previous Message Dennis Breithaupt 2004-06-11 15:25:55 Re: lost pg_xlog (SOLVED)