Re: I do not get the point of the information_schema

2018-02-14 Thread Eric Hanson
You might find Aquameta's meta module helpful, it reimplements information_schema in a more normalized layout, as updatable views: http://blog.aquameta.com/2015/08/29/intro-meta/ https://github.com/aquametalabs/aquameta/tree/master/core/000-meta Best, Eric On Mon, Feb 12, 2018 at 2:02 PM

Re: I do not get the point of the information_schema

2018-02-13 Thread Tom Lane
"David G. Johnston" writes: > Unless our docs are completely misleading I'd say that PostgreSQL is being > conforming while MariaDB is treating information_schema as their version of > pg_catalog (or at least our system views over top of pg_catalog). Our project

Re: I do not get the point of the information_schema

2018-02-13 Thread David G. Johnston
On Tue, Feb 13, 2018 at 4:17 PM, Peter J. Holzer wrote: > > It is possible that all the columns that PostgreSQL has are required by > the standard and that MariaDB is non-conforming by omitting them, but at > least some of the names look quite PostgreSQL-specific to me. So my >

Re: I do not get the point of the information_schema

2018-02-13 Thread Peter J. Holzer
On 2018-02-13 16:06:43 -0700, David G. Johnston wrote: > On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote: > > (That said, it looks like both PostgreSQL and MariaDB include additional > columns beyond those mandated by the standard - you can't rely on those, >

Re: I do not get the point of the information_schema

2018-02-13 Thread David G. Johnston
On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote: > (That said, it looks like both PostgreSQL and MariaDB include additional > columns beyond those mandated by the standard - you can't rely on those, > of course. And some databases like Oracle don't even have an

Re: I do not get the point of the information_schema

2018-02-13 Thread Peter J. Holzer
On 2018-02-12 23:01:41 +0100, Thiemo Kellner wrote: > I try to implement SCD2 on trigger level and try to generated needed code on > the fly. Therefore I need to read data about the objects in the database. So > far so good. I know of the information_schema and the pg_catalog. The > documentation

Re: I do not get the point of the information_schema

2018-02-12 Thread Tom Lane
Thiemo Kellner writes: > I try to implement SCD2 on trigger level and try to generated needed > code on the fly. Therefore I need to read data about the objects in the > database. So far so good. I know of the information_schema and the > pg_catalog. The