Re: [GENERAL] information schema extra fields

2004-12-10 Thread Michael Glaesemann
On Dec 9, 2004, at 12:46 PM, Ron Peterson wrote: I was just reading the PostgreSQL documentation about Information Schemas. Some of the tables have fields which are described as "Applies to a feature not available in PostgreSQL" The information schema is a part of the SQL standard that allows acce

Re: [GENERAL] information schema extra fields

2004-12-10 Thread Ron Peterson
On Sat, Dec 11, 2004 at 11:58:31AM +0900, Michael Glaesemann wrote: > On Dec 9, 2004, at 12:46 PM, Ron Peterson wrote: > > >I was just reading the PostgreSQL documentation about Information > >Schemas. Some of the tables have fields which are described as > > > >"Applies to a feature not availabl

[GENERAL] information schema extra fields

2004-12-10 Thread Ron Peterson
I was just reading the PostgreSQL documentation about Information Schemas. Some of the tables have fields which are described as "Applies to a feature not available in PostgreSQL" What does that mean? -- Ron Peterson Network & Systems Manager Mount Holyoke College http://www.mtholyoke.edu/~rpe

Re: [GENERAL] Information Schema - Can the views be applied to older versions of PostgreSQL

2004-06-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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? I doubt they would just drop in, but you could possibly adapt them to mostly work... regards, tom lane -

Re: [GENERAL] Information Schema - Can the views be applied to older versions of PostgreSQL

2004-06-11 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > 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? No. For your purposes, you maybe be able to backport them and distribute the altered versions with your product. For some cases this

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

2004-06-11 Thread mike . griffin
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

Re: [GENERAL] information schema

2004-05-30 Thread Tom Lane
Wei Shi <[EMAIL PROTECTED]> writes: > Does anybody know why "key_column_usage", and > "referential_constraints" are empty in > information_schema? They work for me ... regards, tom lane ---(end of broadcast)--- TIP 2: you ca